topic Re: Current selection not working with set analysis in QlikView

Current selection not working with set analysis

Deepak13 — Fri, 28 Feb 2020 05:03:42 GMT

Hello All

I have below expression in my pivot table

=(sum({$<Source={'X'}>}Cost)-sum({$<Source={'Y'}>}Cost))/1000.

the pivot table with above expression is not responding to my current selection. Please help

regards

Re: Current selection not working with set analysis

jonathandienst — Fri, 28 Feb 2020 05:11:01 GMT

Do you mean its not responding to a selection of the Source field? Thats because the expression sets the value to be used. Or perhaps you mean other selections as well - in which case the problem probably arises from the data model.

Re: Current selection not working with set analysis

Deepak13 — Fri, 28 Feb 2020 05:23:19 GMT

I have 3 pivot tables

table1 has following expression

sum({$<Source={'X'}>}Cost)/1000

table2 has following expression

sum({$<Source={'Y'}>}Cost)/1000

And the 3rd table is basically the subtraction of the above 2 tables

=(sum({$<Source={'X'}>}Cost)-sum({$<Source={'Y'}>}Cost))/1000

the first 2 are responding to the current selection but not the 3rd .

Re: Current selection not working with set analysis

Deepak13 — Fri, 28 Feb 2020 05:44:16 GMT

I checked the expression for first 2 tables its was simply sum(cost).

apologies for the confusion, i assumed that filtering is done in set analysis for the first 2 tables, rather it was done using calculated dimension.

for the 3rd table i simply removed the $ sign from the expression and its now filtering records according to the current selection.

Regards