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: 
Not applicable

Problem with Set Analysis

Guys, I am using this expression for set analysis:

=num#(SUM({<[UNIQUE_FLAG]={1}, [Status Claim] -={Cancelled}>}([Total Approved])*[Rate]),'USD #,##0.00', '.',',')

I use this expression to my map bubble size

Problem occurs that this expressions gets the total approved of all years, and I want only for the year selected... I have this other field called "YEAR", and I want it added to this expression... so, lets suppose:

YEARTotal Approved
201010
201120
201230
201340
201450
Total

150

So, When I pick one year, for example, 2011, it gets for me a ratio 20:150 and distribute the points in the map. I would like to get only that 20 and distribute in the map, not the ratio...

I am using the open street map extension attached...

Can someone help me out on this matter, pelase?

3 Replies
Not applicable
Author

It seems that my problem is solved when I turn on/off the webview and change the year when the webview is off...

Does anyone know how that work?

SunilChauhan
Champion II
Champion II

use Year={$(=Max(Year))} in your expression


num#(SUM({<[UNIQUE_FLAG]={1},Year={$=(Max(Year))} ,[Status Claim] -={Cancelled}>}([Total Approved])*[Rate]),'USD #,##0.00', '.',',')


hope this helps

Sunil Chauhan
Not applicable
Author

nope, it looks like a bug, or something like it... I turn off and then I turn on the web view and then it starts to work fine...