4 Replies Latest reply: Apr 13, 2015 5:00 AM by Joanna Seldon RSS

    combo chart, line and bar

    Joanna Seldon


      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

        • Re: combo chart, line and bar

          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

            • Re: combo chart, line and bar
              Joanna Seldon

              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