Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Current selection not working with set analysis

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Re: Current selection not working with set analysis

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

 

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Current selection not working with set analysis

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. 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor II
Contributor II

Re: Current selection not working with set analysis

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 .

Highlighted
Contributor II
Contributor II

Re: Current selection not working with set analysis

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

 

View solution in original post