Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Formatting on Y axis qlikview line chart

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

6 Replies
Anonymous
Not applicable

In the expression used divide it by 100.

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

deepakqlikview_123
Specialist
Specialist
Author

No This does not work.

I am using below expression.,

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

Thanks

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable

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
Partner - Specialist II
Partner - Specialist II

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

deepakqlikview_123
Specialist
Specialist
Author

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