1 Reply Latest reply: Oct 15, 2013 9:08 AM by Friedrich Hofmann RSS

    Combo_chart with two expressions - write in the columns?

    Friedrich Hofmann

      Hi,

       

      I have a combo chart displaying a completion_status (between 0% and 100%) of two elements:

      - QlikView apps

      - the resp. documentations

      There are two columns for every dimension_point side by side

      They are all coloured acc. to the range of their value, so they may have the same colour

       

      => I would like to make it easier to tell which is which, either by using a second dimension (I tried that, but it didn't show?!)

           or preferably by writing "App" or "documentation" inside the columns - is that possible?

       

      Thanks a lot!

      Best regards,

       

      DataNibbler

        • Re: Combo_chart with two expressions - write in the columns?
          Friedrich Hofmann

          Hi,

           

          I have looked up the DUAL() fct. and implemented that in my script:

          - There are two fields in my base file:

            - Teamboard

            - Status

          - I would like to display the Status on the y-axis of my chart, but display the name of the Teamboard, not only as dimension, but within the column as well.

          => I have one line in my LOAD statement that reads

          >>> DUAL(Status, Teamboard) as Status <<<

           

          However, when i reload, the chart gets very big and the y-axis disappears altogether.

           

          Can someone help me here?