topic Re: Dollar Sign in Y axis in QlikView

Dollar Sign in Y axis

mhmmd_srf — Sat, 16 Nov 2024 04:08:08 GMT

Hi All,

I have a bar chart, Category by Sales. Need to show sales in Dollar. And I want to show Dollar sign in Y axis as well.

How can I do this with out using Static properties.

I am attaching sample App.

Thanks,

Sarif

JoshuaSolomon — Mon, 18 Mar 2019 11:14:58 GMT

Hi,

mhmmd_srf — Mon, 18 Mar 2019 11:18:06 GMT

Hi Solomon,

I have already tried all the approaches mentioned in the thread. Nothing is working.

Can you please try once from your end, may be I am doing anything wrong.

Thanks,

Sarif

anushree1 — Mon, 18 Mar 2019 11:44:34 GMT

I placed the Sales($) on Y-axis , its already there on bars .

So is this what you are looking for? please check the attached

Zhandos_Shotan — Mon, 18 Mar 2019 12:00:28 GMT

Hi!

Trick from:

works well if you display your values in Million $.

So you need:

1. Static step =1

2. Sum(Sales)/1000000

3. Symbol property ='M'

Check the attachment.

Regards!