topic Re: Showing a certain value if condition is met in QlikView

Showing a certain value if condition is met

Thu, 27 Apr 2017 13:54:32 GMT

What I am trying to show is the percentage of fees not paid by dividing two fields, TotalOutstanding (A) and TotalPaid (A). In some cases A is greater than B so the rate is > 100.

What I want is, if the amount is greater than 100, show 100%, else show the calculated amount

This is what i have so far

if(

(Sum (TOTALOUTSTANDING)/Sum (TOTALPAID)*100 >= '100')

, '100%',

SUM(TOTALOUTSTANDING)/Sum (TOTALPAID)*100

)

Re: Showing a certain value if condition is met

prieper — Thu, 27 Apr 2017 14:06:24 GMT

Would use formatting in percent, thus 100% = 1. Formula may then look:

if(

(Sum (TOTALOUTSTANDING)/Sum (TOTALPAID) >= 1)

, 1,

SUM(TOTALOUTSTANDING)/Sum (TOTALPAID)

)

HTH Peter

Re: Showing a certain value if condition is met

Thu, 27 Apr 2017 14:11:11 GMT

This is what I have under the numbers tab

Re: Showing a certain value if condition is met

prieper — Thu, 27 Apr 2017 14:21:03 GMT

seem to be ok

and ...

does it work?

Re: Showing a certain value if condition is met

Thu, 27 Apr 2017 14:22:01 GMT

it does not

Re: Showing a certain value if condition is met

vishsaggi — Thu, 27 Apr 2017 14:24:13 GMT

May be Try like:

if(

Num(Sum (TOTALOUTSTANDING)/Sum (TOTALPAID) , '###0') >= '100' )

, '100' &'%',

Num(SUM(TOTALOUTSTANDING)/Sum (TOTALPAID) , '#,##0%')

)

Can you share a sample if still have issues?

Re: Showing a certain value if condition is met

Thu, 27 Apr 2017 14:26:50 GMT

It says Error in Expression

Re: Showing a certain value if condition is met

prieper — Thu, 27 Apr 2017 14:32:47 GMT

see attached

Peter

Re: Showing a certain value if condition is met

Thu, 27 Apr 2017 14:38:58 GMT

I dont know why it isnt working for me

Re: Showing a certain value if condition is met

prieper — Thu, 27 Apr 2017 14:46:56 GMT

then please check the fieldnames, formula in your application same as sent to you ....

Are your fields numeric fields?

Peter

Re: Showing a certain value if condition is met

Thu, 27 Apr 2017 14:53:30 GMT

i created another chart, and its showing 1. Now i justt have to change the number field. So your solution helped. Thanks!

Re: Showing a certain value if condition is met

Thu, 27 Apr 2017 14:59:23 GMT

It's not showing as a percentage