topic Re: percentage difference in QlikView

percentage difference

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

Hi All,

I want to find percentage difference between 2 percentages.

So, in 3rd expression i want to show difference(comparing current and previous month percentages). Also, If the MaxMonth has more than 5% decrease compared to previous month then i want to show the 3rd expression in green background.

expr1- sum({<MonthYear = {"$(vMaxMonth)"}>}Margin)/sum({<MonthYear = {"$(vMaxMonth)"}>}Sales)

expr2- sum({<MonthYear = {"$(vPreMonth)"}>}Margin)/sum({<MonthYear = {"$(vPreMonth)"}>}Sales)

expr3- Column(1) - Column(2)

Please help.

Re: percentage difference

sunny_talwar — Wed, 28 Feb 2018 10:13:33 GMT

You want this?

Re: percentage difference

surajap123 — Wed, 28 Feb 2018 11:00:57 GMT

Sorry, attached wrong app earlier.

Hi Sunny,

Thank you so much for the solution.

I have a query. If i format the 1st and 2nd expressions with num() function(and disabled percentage checkbox in number tab), then i see the 3rd expression is not working.

eg-

num(sum({<MonthYear = {"$(vMaxMonth)"}>}Margin)/sum({<MonthYear = {"$(vMaxMonth)"}>}Sales)*100,'0.00%')

!Could you please help.

Re: percentage difference

sunny_talwar — Wed, 28 Feb 2018 12:05:56 GMT

I guess what exactly would you want to see? Remove percentage from the number's tab to see this

Is there a reason you are formatting using Num() function rather than using the number's tab?

Re: percentage difference

surajap123 — Wed, 28 Feb 2018 12:11:10 GMT

Thanks for the clarification.:)

I was trying various ways to understand the behaviour.