Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get filters to work with a crosstable election?

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?

2 Replies
jmvilaplanap
Specialist
Specialist

Hi,

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

Anonymous
Not applicable
Author

Sure thing

Capture.PNG