Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi!
Trick from:
https://qlikviewcookbook.com/2015/05/currency-and-other-symbols-on-the-y-axis/
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!
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
I placed the Sales($) on Y-axis , its already there on bars .
So is this what you are looking for? please check the attached
Hi!
Trick from:
https://qlikviewcookbook.com/2015/05/currency-and-other-symbols-on-the-y-axis/
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!