Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Exclude Selection from Expression

hi all,

the following expression works fine for me and supposed to make calculation for specific name as added on the set analysis.

Now when I go on my list box "Name" and make different selection, it changes the numbers and give wrong values. how can I make sure the values dont change when I select a value on the Name column?

RangeSum(Above(

((Sum({$<Flag  = {'1'}, [Name]= {'ABC'}>}[Price]) - above(Sum({$<Flag  = {'1'}, [Name]= {'ABC'}>}[Price]))) 

/  ([Date] - above([Date]))

-

0.06)

*

([Date] - above([Date]))  ,  0,RowNo())))

20 Replies
alec1982
Specialist II
Specialist II
Author

so I created another measure and add the second expression with if. I see the numbers just fine.. when I combine them into one all works then when I select a different name I get wrong values....