topic Re: Dual axis line and dotted chart in QlikView

Dual axis line and dotted chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to see a dual axis line graph that shows a line for current year sales and a separate dotted line for previous year sales and growth percentage on the same graph. Sample image has been attached for the same. My condition is as below:

1) If i have selected the timeline filter as 12 month and another filter as month then two line chart should display the sales data and growth % of current year and previous year sales data.

2) If i have selected the timeline filter as 12 month and another filter as rolling 4 months then two line chart should display the rolling 4 months sales data and growth % of current year and previous year sales data.

and so on.

Chart should have dual axis.

Thanks in advance!!

Rohit

Re: Dual axis line and dotted chart

vinieme12 — Tue, 06 Jun 2017 08:53:49 GMT

please post a sample app

Qlik Community Tip: How to Get Answers to Your Post

Uploading a Sample

Re: Dual axis line and dotted chart

Wed, 07 Jun 2017 12:21:13 GMT

Hi Vineeth,

We can't share the QVW with you as it contains the sensitive client information. My requirement is to see the data for current year vs previous year. Calculation i.e %Growth is performed on the basis of ((Current Year)/(Previous Year) -1)

Please find the sample requirement for the same.

Re: Dual axis line and dotted chart

vinieme12 — Wed, 07 Jun 2017 12:24:26 GMT

No one needs to see your actual data; just some sample/dummy data that best represents the data set you are working with

Re: Dual axis line and dotted chart

prieper — Wed, 07 Jun 2017 12:32:24 GMT

Might be worth to think about constructing two charts, of which only one is visible, depending the selections...

Dual axis can be arranged under Properties->Axes->Position

For each expression you may open the small "+" and under "Line Style" you may enter '<Sn>' (n from 0 to 4) in order to change the line-style.

Thickness etc. of the lines can be changed under Properties -> Presentation