topic Re: % Issue Calculation in QlikView

% Issue Calculation

NavinReddy — Thu, 15 Feb 2018 14:48:42 GMT

Hello all,

Below formula its working for only numbers, its not working for percentage.

please find the attached sample app,please help me

=num((CM-PM))/PM

Thanks in Advance

Niranjan

Re: % Issue Calculation

rubenmarin — Thu, 15 Feb 2018 15:01:00 GMT

It's caused by the strings added to the numbers, if &' ' is removed it starts to work.

Re: % Issue Calculation

NavinReddy — Thu, 15 Feb 2018 15:09:04 GMT

Please help me where to remove the if &' ', im not sure where to remove.

Re: % Issue Calculation

YoussefBelloum — Thu, 15 Feb 2018 15:14:15 GMT

there is an error on your expressions, this field don't exist: ELE_VALUE_DCML_CT

Re: % Issue Calculation

rubenmarin — Thu, 15 Feb 2018 15:16:27 GMT

In the number formats of the 'PCT' types there is a "&' '", PFA.

Re: % Issue Calculation

NavinReddy — Thu, 15 Feb 2018 16:47:56 GMT

Hi Ruben,

Thanks you very much its working, now i have to fileter only <=-50% and >=50%.

=IF((Percentage>=50% or Percentage<=-50%),Percentage,'NUll') -- with this code im getting only Null Values.

Need your help

Many thanks

Re: % Issue Calculation

NavinReddy — Thu, 15 Feb 2018 18:17:25 GMT

i have to filter only <=-50% and >=50%. below expression is not working please help me

=IF((Percentage>=50% or Percentage<=-50%),Percentage,'NUll')

Re: % Issue Calculation

rubenmarin — Thu, 15 Feb 2018 18:28:10 GMT

You can try:

=If(Fabs((CM-PM)/PM)>=0.5, (CM-PM)/PM)

Re: % Issue Calculation

NavinReddy — Thu, 15 Feb 2018 18:37:56 GMT

Thanks you very much Yes its working, just want to understand the logic.

Re: % Issue Calculation

rubenmarin — Fri, 16 Feb 2018 07:28:49 GMT

Fabs() returns the absolute value (always positive), the expression only checks if the absolute value is above or equal to 50% (0.5=50%), in that case it shows the percentage.