topic Re: To operate two column in same pivot table on two different filters in App Development

To operate two column in same pivot table on two different filters

Saurabh07 — Mon, 20 Dec 2021 21:08:46 GMT

Hello,

Had a quick question, I have created Qlik app where I am loading the data and creating two resident tables with different 'Dates', post that in the front end I am trying to select the dates from the filter where I have added an expression using GetFieldSelection so that I get the information from the resident table. This is not working and I am getting a desired output.

The basic idea here is to operate two column in same pivot table on two different filters. Changes should happen in each of the column in based on selections made in corresponding filters. Is this possible and if yes, any kind of help would be highly appreciated!

Re: To operate two column in same pivot table on two different filters

Kushal_Chawda — Sat, 03 Oct 2020 21:11:11 GMT

@Saurabh07 You can Create separate expressions for both the filters. In expression you can exclude the selection of filter using set analysis. Let's say you are creating expression for filter 1, then you can exclude the selection of filter 2 in that expression. Then you can have conditional expression for measures based on filter selections.

Re: To operate two column in same pivot table on two different filters

Saurabh07 — Thu, 08 Oct 2020 07:57:56 GMT

@Kushal_Chawda Hey Kush, thank you. This just helped me.