topic Re: Formatting on Y axis qlikview line chart in QlikView

Formatting on Y axis qlikview line chart

deepakqlikview_123 — Tue, 17 Feb 2015 10:38:42 GMT

Hi All,

PFA.

On y axis i want to show GDP as 2%.4% instead of 200%,400%

Can you please suggest how shall i go ahead.

Thanks

Anonymous — Tue, 17 Feb 2015 10:41:37 GMT

In the expression used divide it by 100.

If that does not work then could you share the expression.

deepakqlikview_123 — Tue, 17 Feb 2015 10:46:53 GMT

No This does not work.

I am using below expression.,

sum(if(Indicator_name='% Of GDP',Indicator_value))

Thanks

jonathandienst — Tue, 17 Feb 2015 11:05:24 GMT

sum(if(Indicator_name='% Of GDP',Indicator_value)) / 100

Anonymous — Tue, 17 Feb 2015 11:06:03 GMT

For one datapoint :

What value does this give

sum(if(Indicator_name='% Of GDP',Indicator_value))

And what value does this give

sum(if(Indicator_name='% Of GDP',Indicator_value)) / 100

manojkulkarni — Tue, 17 Feb 2015 11:17:45 GMT

Pls check, if value is coming as percentage then make sure you uncheck the percentage under number formatting.

deepakqlikview_123 — Tue, 17 Feb 2015 11:53:56 GMT

Hi All,

It is working fine.But when i can apply static step result disappears.

Req is i want to show result by using static step that is diff of 2.

Please suggest

Thanks