Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change y axis Values

Hi all ,

How to change y-axis values from Rupees to Lacs, PFA

Thanks.

3 Replies
PrashantSangle

Hi,

divide by 100000 in your expression

Try like

Sum(Sales)/100000

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

Create a inline table like below...

LOAD * Inline

[

Ftr, Ftr_Val

Actual, 1

Thousands, 1000

Lacks, 100000

Crores, 10000000

];

1.Load the above inline table in the application.

2.Create a list box  as Ftr and select always one selected option enabled.

3.In the expression use "sum(Sales)/$(=Ftr_Val)".

Hence according to your factor selection you can view the values.

Thanks,

Vignesh

engishfaque
Specialist III
Specialist III

Dear Janaki,

Step 1:

Expression: Sum(Sales/100000)

Step 2:

Chart Properties > Tab "Number" > Select "Expression" > Select Radio Box "Mondy" > Symbol > write your symbol for  Lacs > Apply > OK.

lacs.png

Kind regards,

Ishfaque Ahmed