topic Re: different axis preferences for alternative dimensions in QlikView

different axis preferences for alternative dimensions

mhapanka — Mon, 10 Sep 2018 18:50:22 GMT

Hi,

I have a stacked bar chart showing sales. The dimensions are sales and years. thus it shows sales over years- 2016, 2017 and 2018

I added an alternative measure showing % of sales across years by using sum(sales)/ sum(total<dim1>sales)

however since the max on y axis is 100M, when the dimension is chosen as the sum(sales)/ sum(total<dim1>sales) the y axis shows as 100000000%

How do I keep different axes limits for different dimensions?

santhana — Mon, 10 Sep 2018 19:17:05 GMT

Hi Mallika,

go to Axes tab and select right top option of position for second expression find the snap below

I hope you are looking for this if I understood your query

mhapanka — Mon, 10 Sep 2018 19:28:11 GMT

Hey i dont have this view, working in qliksense