Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

deepaktibhe
Valued Contributor

Showing dollar sign as well as decimals on qlikview line chart

Hi,

after using dollar sign in number tab and  fixing decimals as well as fixing  axis i am getting dollar sign as well as  point values

on both mouse over values as well as on y axis

As per requirement i need to show dollar sign after each step on y axis and should not have any decimals

but on mouse over value should be up to 2 decimals and should not have dollar

sign.

i need to plot line chart also in this manner.But in line chart it is showing values for both expression .

thanks

3 Replies
vardhancse
Valued Contributor II

Re: Showing dollar sign as well as decimals on qlikview line chart

Expression->show data points(Enable check box)

Not applicable

Re: Showing dollar sign as well as decimals on qlikview line chart

PLEASE ENABLE    CHECK BOX  FOR  "VALUES ON DATA POINT"

Re: Showing dollar sign as well as decimals on qlikview line chart

Hi,

Try to change your expression like the below

before the Avg expression add num format. num(YourExpression, '$#,##0')

=if(isnull(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'}>}INDICATOR_VALUE)) or

num(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'}>}INDICATOR_VALUE),'$#,##0')=0,

num(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE),'$#,##0'),

num(Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},FRQ_TYPE={'A'},QUARTER={'Q4'}>}INDICATOR_VALUE),'$#,##0')

)

I think, one expression is fine for this chart.

And, in the Number's Tab -> Set Expression Default.

And, Axis Tab -> Static Min = 0

                          Static Max=250

                          Static Step = 50

you can change the value based on your requirement.

find the attached for further reference.

Community Browser