Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
anonymous1
New Contributor III

set analysis on expression

hey,

i need this expression to not be impacted by any selections:

=NUM((sum(TOTAL_SALES) - sum(SALES)/ sum(TOTAL_SALES), '0.00%')

i tried:

=NUM((sum({1}TOTAL_SALES) - sum({1}SALES))/ sum({1}TOTAL_SALES), '0.00%')

but this doesnt work 

any advice is much appreciated

Labels (2)
2 Replies
Partner
Partner

Re: set analysis on expression

Whats the issue you are getting?
Code seems right
anonymous1
New Contributor III

Re: set analysis on expression

when I make a selection on my dashboard, this expression keeps changing