Formatting on Y axis qlikview line chart

[deepakqlikview_123]

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]

In the expression used divide it by 100.

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

[deepakqlikview_123]

No This does not work.

I am using below expression.,

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

Thanks

[jonathandienst]

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

[Anonymous]

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]

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

[deepakqlikview_123]

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