topic Re: percentage calculation in UI in QlikView

percentage calculation in UI

pawwy1415 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me to calculate the below expected output column in UI

From Proftloss dimension need to calculate the percentageprofitloss

Logic is percentageprofitloss is aggregated by Deskid and date.

here 5.7 is claulated as

=(profitloss/deskid,asofdate aggregated total profit loss)*100

=(3.15/(0+3.15+0-58.45))*100

=5.7

when ever profit loss is null then it need to display 0

Please help me to calculate the above expression.

Thanks in advance.

Re: percentage calculation in UI

sunny_talwar — Thu, 19 Apr 2018 11:28:26 GMT

May be this

Sum(profitloss)/Sum(TOTAL <Deskid> profitloss)

Re: percentage calculation in UI

sunny_talwar — Thu, 19 Apr 2018 11:40:54 GMT

What did you get? the values you shared? Use percentage as formatting or multiply by 100

Sum(profitloss)/Sum(TOTAL <Deskid> profitloss) * 100

Re: percentage calculation in UI

pawwy1415 — Thu, 19 Apr 2018 13:25:51 GMT

Hi Sunny,

The above expression is working fine in Straight table with multiple dimensions.

But when I have used the same expression in Line chart with Date dimension getting 100 for all the dates even by fliting the other dimensions also its not changing.

Could you please help me on this.

Thanks in advance.

Re: percentage calculation in UI

sunny_talwar — Thu, 19 Apr 2018 13:34:30 GMT

Sure, would you be able to share a sample to show the issue?