Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Select Postcode Polygon field in map. Filter pivot table with second dimension

Hi all,

i have a sheet with a Pivot table with our turnover per month. Underneath there is a map showing the post code Areas of Germany and the Polygons have a colour changing formula with the changing rate of Revenue per post code area.

All works fine. If I select a post code area the Pivot table filters perfectly on that post code (first two Digits eg. 48 of 48527).

Problem is that there are foreign revenues where the Post code Begins with the same two Digits so that the graphic is correct but the table is not.

Is that possible to say when filter PLZ2 is set the pivot table must also filter on Country code = de but only then?

Thanks in advance

Matt

2 Replies
Employee
Employee

Re: Select Postcode Polygon field in map. Filter pivot table with second dimension

I would personally just create another field in your data-model, that's probably the easiest solution.

Regards

Stefan

Not applicable

Re: Select Postcode Polygon field in map. Filter pivot table with second dimension

There is a second field in the Dataset but it must automatically be filtered when selecting the Postcode Polygon in the map in order to filter the Pivot table correct.

Best regards

Matthias

Community Browser