How to get filters to work with a crosstable election?

[Anonymous]

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?

[jmvilaplanap]

Hi,

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

[Anonymous]

Sure thing