# 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
Did you mean:
Highlighted 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.

regards

Tags (1)
1 Solution

Accepted Solutions
Highlighted 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

3 Replies
Highlighted 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

## 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

## 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