topic Re: Change y axis Values in QlikView

Change y axis Values

Tue, 30 Dec 2014 05:10:43 GMT

Hi all ,

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

Thanks.

PrashantSangle — Tue, 30 Dec 2014 05:15:47 GMT

Hi,

divide by 100000 in your expression

Try like

Sum(Sales)/100000

Regards

Anonymous — Tue, 30 Dec 2014 05:27:44 GMT

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 — Tue, 30 Dec 2014 05:52:26 GMT

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.

Kind regards,

Ishfaque Ahmed