How to get filters to work with a crosstable election?

Anonymous — Thu, 20 Jul 2017 15:36:44 GMT

Using the example table found here Working with crosstables in the data load script ‒ Qlik Sense where we have the LOAD statements as

Main:

LOAD

"Year",

Jan,

Feb,

Mar,

Apr,

May,

Jun

FROM [lib://Desktop/cross.xlsx]

(ooxml, embedded labels, table is Sheet1);

Cross:

crosstable (Month, Sales) LOAD * Resident Main;

If I create a pie chart using 'Month' as the Dimension and Sum('Sales') as the Measure then try to select a filter from that pie chart, the other charts that are not using data from the pie chart do not update. However, selections from other charts (such as a bar chart with 'Year' as the Dimension and sum('Apr') as the Measure) properly update the pie chart. Any insight as to why?

Re: How to get filters to work with a crosstable election?

jmvilaplanap — Thu, 20 Jul 2017 16:32:19 GMT

Hi,

Could you show the data model? Maybe the name of the fields are wrong.

Re: How to get filters to work with a crosstable election?

Anonymous — Thu, 20 Jul 2017 16:57:54 GMT

Sure thing

topic Re: How to get filters to work with a crosstable election? in App Development

How to get filters to work with a crosstable election?

Re: How to get filters to work with a crosstable election?

Re: How to get filters to work with a crosstable election?