[adamParticipant]

Thank you so much Martin for the example, works perfectly. Really appreciate it.
The columnmenuopening property is so useful and the fact that one of the parameters is datafield means I can make the width changes for various columns conditional to prevent exceptions in Id not being found.

Thank you again for your help.

[adamParticipant]

Thank you Martin for your reply and the example. The example is fine for that type of filter, however it is not possible to alter css to increase width for checkedlist filter. One instance is when the values are few and the other many when you have a checkedlist filter. Please change the example you provided by making one of the columns to filtertype: ‘checkedlist’ and also try three instances, first where you have horizontal scrollbar and vertical, then where you have horizontal but no vertical scrollbar and last where you have vertical scroll bar but no horizontal. Also cannot control scroll icon to move past the set.

Much help will be appreciated. Thank you

[adamParticipant]

Thank you Hristo for your response.
First, the example you gave does not format the date correctly on the x-axis. The format rendered on the x-axis is 31-Jan-2017 instead of 01/31/2017.
The main issue is that whatever you do, if all values on that axis contain valid dates internally jqWidgets thinks the data is dates. I would like to treat them as strings rather than dates, like labels. Lets say I change the example you gave to this, then this doesn’t work because the datafield partNumber now is being converted to date value when i dont want it to:

var otherDataThatDOESNTWorksInIE11 = [{"partNumber":"03/31/2018","petrol":104,"diesel":24},{"partNumber":"06/30/2018","petrol":134,"diesel":32},{"partNumber":"09/30/2018","petrol":104,"diesel":24},{"partNumber":"12/31/2017","petrol":164,"diesel":40},{"partNumber":"12/31/2018","petrol":74,"diesel":16}];

var source =
    {
      datatype: "json",
      datafields: [
        { name: 'partNumber', type: 'string' },
        { name: 'petrol' },
        { name: 'diesel' }
      ],
      localdata: otherDataThatDOESNTWorksInIE11
    };
var dataAdapter = new $.jqx.dataAdapter(source, { async: false, autoBind: true, loadError: function (xhr, status, error) { alert('Error loading "' + source.url + '" : ' + error); } });

// prepare jqxChart settings
var settings = {
  title: "Faulty chart",
  description: "example of Faulty chart",
  enableAnimations: true,
  showLegend: true,
  padding: { left: 5, top: 5, right: 5, bottom: 5 },
  titlePadding: { left: 90, top: 0, right: 0, bottom: 10 },
  source: dataAdapter, //otherDataThatDOESNTWorksInIE11,
  colorScheme: "scheme01",
  xAxis: {
    dataField: "partNumber",
  },
  valueAxis: {
    unitInterval: 10,
    minValue: 0,
    maxValue: 150,
    visible: true,
    title: { text: "Amount<br>" },
    gridLines: { color: "#888888" }
  },
  seriesGroups: [
    {
      type: "stackedcolumn",
      columnsGapPercent: 100,
      seriesGapPercent: 5,
      series: [
        { dataField: "petrol", displayText: "petrol", color: "#BA3C38" },
        { dataField: "diesel", displayText: "diesel", color: "#277FE6" }
      ]
    }
  ]
};

$("#jqxChart").jqxChart(settings);

In any case, what i would like is to treat the x-value data as strings not as dates but this is not possible. Please have a look.

[adamParticipant]

Hi,

It appears that for jqxGrid filtertype checkedlist does not work for columns with null values and those that are cells formatted. Please see the following fiddle Grid not filtering fiddle
In the fiddle, selecting none for the first three columns does not remove all the rows. Thank you

[Author]

Posts