Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
tezewike
New Contributor

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
Valued Contributor

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

Hi,

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

tezewike
New Contributor

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

Sure thing

Capture.PNG

Community Browser