QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for
Did you mean:
Creator III

percentage calculation in UI

Hi Experts,

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

1 Solution

Accepted Solutions
MVP

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

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

4 Replies
MVP

May be this

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

MVP

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

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

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.