Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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....