Discussion Board for collaboration related to QlikView App Development.
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
when ever profit loss is null then it need to display 0
Please help me to calculate the above expression.
Thanks in advance.
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
May be this
Sum(profitloss)/Sum(TOTAL <Deskid> profitloss)
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.
Sure, would you be able to share a sample to show the issue?