Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a combo chart. in qlik sense
Year 1 is the bars and previous year 2 is the line.
calculations work fine, so its doing the sums, however chart appears as
jan to dec as line Previous year 2...then jan to dec starts again as bars. Year 1
however I want I wish for the line to appear on top of the bars. just one set jan to dec to show the difference. like a trend line.
code used
count({<[Arrival Year]={$(=max([Arrival Year]))}>}[Age]) (bars)
count({<[Arrival Year]={$(=max([Arrival Year])-1)}>}[Age]) (line)
they are joined together if I add alt1
count({alt1<[Arrival Year]={$(=max([Arrival Year])-1)}>}[Age])
but then line is not spiking. the line the just runs along the bottom of the bars.
please help
Kind regards
Joeybird
Hi Joeybird,
Attached is a quick and simple app which is my understanding of what you are trying to achieve.
The first chart is trying to replicate the initial yr1/2 comparison and the second chart has both years plus a variance line being the difference between the years.
Hope this helps.
Kind regards,
Rod
Hi joeybird,
I think you need to put the trend measure onto the second axis.
To do this, under the measure settings, make sure the measure is set to display as Line and then choose Secondary Axis from the box underneath.
Hope this helps.
Kind regards,
Rod
Hiya
tried this and no joy.
however bar is now in the middle (not running along the bottom), but still no spiking when you use
count({alt1<[Arrival Year]={$(=max([Arrival Year])-1)}>}[Age]).
when I use this below I do get the spikes....
count({<[Arrival Year]={$(=max([Arrival Year])-1)}>}[Age]) (line)
but the spiked line (Year 2/ previous year) goes across then (year 1/ current year) starts in bars.
Please help?
Kind Regards
Joeybird
Hi Joeybird,
Attached is a quick and simple app which is my understanding of what you are trying to achieve.
The first chart is trying to replicate the initial yr1/2 comparison and the second chart has both years plus a variance line being the difference between the years.
Hope this helps.
Kind regards,
Rod
Hiya
this worked amazingly.
Thank you
I have tried to see where I was going wrong is
previous year (2) should be on primary axis, not secondary for a line.
Kind Regards
Joeybird x