Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Partner
Partner

Re: set analysis on expression

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

Re: set analysis on expression

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