Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
devarasu07
Not applicable

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

Re: Conditional calculated measure in front end?

This:

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

3 Replies
sunny_talwar
Not applicable

Re: Conditional calculated measure in front end?

This:

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

devarasu07
Not applicable

Re: Conditional calculated measure in front end?

Hi Sunny,

It's Working perfectly, Thanks

sunny_talwar
Not applicable

Re: Conditional calculated measure in front end?

Another approach using set analysis

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