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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Kunal_Uppal
Contributor
Contributor

Set Analysis using Advance KPI extension

Hi, 

I am trying to calculate the set analysis below using Advanced KPI extension. 

=count({<Date ={">=$(monthstart(max(Date)))<=$max(date))"}, flag={"Agent price"} >}insurance type) * unitprice 

I am able to get the value for the below: 

=count({<Date ={">=$(monthstart(max(Date)))<=$max(date))"}, flag={"Agent price"} >}insurance type)

However, when I try to multiple the above set analysis with the unitprice , it is not rendering any result.

I appreciate if anyone can help me  writing the set analysis with the unit price 

 

Labels (1)
1 Reply
Kunal_Uppal
Contributor
Contributor
Author

I don't have the Sales amount in the table.  I have the data on insurance level, so I would like to calculate the total sales by multiplying with unitprice.