topic Re: Optimize Expression without IF in QlikView

Optimize Expression without IF

Anonymous — Fri, 28 Aug 2015 09:09:39 GMT

Dear all,

This is my expression : Num( Sum(Sale) / Sum( Quantity)*100,'#.#')&'%'

I''d like to reduce '%' when the result of sum equal zero and without IF expression. I need your help,pleaseee!!

Re: Optimize Expression without IF

jonathandienst — Fri, 28 Aug 2015 14:13:55 GMT

Do you mean hide the % when the value is zero?

In what context do you want to display this number?

You could do this:

Num(Sum(Sale) / Sum( Quantity)*100, '0.0%;-0.0%';0)

This will use the appropriate format for positive, negative and zero respectively

Re: Optimize Expression without IF

Anonymous — Sat, 29 Aug 2015 16:11:38 GMT

Thank you very very much jontydkpi‌

Re: Optimize Expression without IF

Anonymous — Mon, 31 Aug 2015 05:15:53 GMT

Hi jontydkpi‌,

I am so sorry about that. Last day, I just check the zero value and I miss to check correct format.

I provide the following photo:

I wanna format % as the left photo. Can you give me advice for this problem?

Regards!

Kirk

Re: Optimize Expression without IF

jonathandienst — Mon, 31 Aug 2015 05:37:36 GMT

Well the %format effectively multiplies by 100, so 0.5 displays as 50%. Just remove the *100 from the expression.

=Num(Sum(Sale) / Sum( Quantity), '0.0%;-0.0%';0)

Re: Optimize Expression without IF

Digvijay_Singh — Mon, 31 Aug 2015 05:53:09 GMT

Do you have Comma ',' before last zero? I guess it should be semicolon. I think 0.0% and -0.0% and the 0 are separated by semicolon and enclosed with apostrophe, try this - '0.0%;-0.0%;0'. jontydkpi might have typo in last response.

Re: Optimize Expression without IF

Anonymous — Mon, 31 Aug 2015 05:58:26 GMT

yup, thank you and.. the number after dot will be rounded.

The data after remove *100 :

I wanna get the number after dot. I dont wanna be rounded number. Like left value. Do you mind if you .... fix it again ? ?