Qlik Community

App Development

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

QlikWorld online is next week! REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

IF works but Set analysis does not work??


I have below expression in my app where i have used IF:

Sum(distinct If(If([Booking Amount] > $(vTopDecile) ,'Y','N')='Y',[Booking Amount],0))

The variable vTopDecile is defined as

fractile(total Aggr(Sum([Booking Amount]),[Opportunity Number],Segment), 0.9)

Now I am trying to write the same expression (the 1st one) using set analysis but that is not working. It always returns 0:

Sum({<[Booking Amount] = {"> $(=vTopDecile)"}>}[Booking Amount])

Can anybody tell me why?

Is it because fractile cannot work with Set Analysis?

Thanks, Prasad

5 Replies

Can you try this (Make sure you don't have space between > and $(

Sum({<[Booking Amount] = {">$(=vTopDecile)"}>}[Booking Amount])

or this

Sum({<[Booking Amount] = {">$(=$(vTopDecile))"}>}[Booking Amount])

Specialist II
Specialist II

It could be is Segment changes for each record. Set Analysis is evaluated once per chart/visualization, not row for row.

Contributor III
Contributor III

1st expression still give 0 but the 2nd one returns value which is wrong.


Your IF has distinct in the aggregation, may be thats making difference -

Sum(distinct {<[Booking Amount] = {">$(=$(vTopDecile))"}>}[Booking Amount])


Would you be able to share a sample to look at this?