Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu07
Master II
Master II

Conditional calculated measure in front end?

Hi All, ‌

attached report is working fine using back end script method. but i'm looking forward to do in front end instead of doing in back end script method.

just need to derive the Regular sales % calculated measure (highlighted red is expected output.)

Regular_Sales.png

Thanks

Deva

1 Solution

Accepted Solutions
sunny_talwar

This:

=Sum(Aggr(If(((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15, Sum(TotalNetPrice)), Country, Product))/SUM(TOTAL <Country,Product> TotalNetPrice)

View solution in original post

3 Replies
sunny_talwar

This:

=Sum(Aggr(If(((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15, Sum(TotalNetPrice)), Country, Product))/SUM(TOTAL <Country,Product> TotalNetPrice)

View solution in original post

devarasu07
Master II
Master II
Author

Hi Sunny,

It's Working perfectly, Thanks

sunny_talwar

Another approach using set analysis

=Sum({<Key = {"=((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15"}>} TotalNetPrice)/SUM(TOTAL <Country,Product> TotalNetPrice)