Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

percentage calculation in UI

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.

1 Solution

Accepted Solutions
sunny_talwar

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

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

View solution in original post

4 Replies
sunny_talwar

May be this

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

sunny_talwar

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

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

View solution in original post

pawwy1415
Creator III
Creator III
Author

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.

sunny_talwar

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