6 Replies Latest reply: Aug 9, 2012 10:34 AM by Siddharth Singh RSS

Stacked Bar Chart

Jigesh Shah

Hi All,

We are working under Qlikview 9.0. system. I am trying to develop a stacked bar chart. I have one dimension (i.e. YYYYMM)  and 30 expressions where i have to create 2 stacked bar chart for each YYYYMM where in 15 expressions are combined to develop one stack and other 15 expressions to create seond stack chart.

I tried a lot but was successful to create only 1 stack considering all 30 expressions for each YYYYMM dimension but not 2 stack bar each with 15 expressions for each YYYYMM.

 

Can somebody please guide me to achieve what i require.

 

 

Thanks.

 

 

Jigesh

  • Re: Stacked Bar Chart
    Martina Brenner

    Hi,

     

    you can use the function Valuelist(), see my example!

     

    Greetings from Munich

     

    Martina

    • Re: Stacked Bar Chart
      Jigesh Shah

      HI Martina,

      THe graph plotted is the same as i want but i hav a fixed dimension called YYYYMM .

       

      IF you can please help me with this.

       

       

      Sorry for late reply.

      THanks for your prompt ans.

       

       

      Jigesh

      • Re: Stacked Bar Chart
        Martina Brenner

        Hi Jigesh,

         

        look at my example again and a nice day

         

        Greetings from Munich

         

        Martina

        • Re: Stacked Bar Chart
          Nicolas MARTIN

          I think what Jigesh wants is something like that:

          tmp.png

          • Re: Stacked Bar Chart
            Jigesh Shah

            Hi Nicolas,

              SOrry for late reply; way too busy at office. The image shown is what i want but in my case i have nly one dimension YYYYMM and multiple expressions...

            Still working around for solution as the director of my company is very fond of stacked bar personally so what trying my best to get it worked but no luck yet...if anyone can please help me out....would b great

             

             

            Thanks Nicolas.

             

             

            Regards,

            Jigesh

            • Re: Stacked Bar Chart
              Siddharth Singh

              Hi Jignesh

              1. In your load script, load the entire data twice.
              2. Create a flag field in the load script and assign it values 1 and 2 (or anything else but 2 distinct values), one for each of the load script bits.
              3. Add flag field as second dimension to your bar chart and suppress the dimension from display.
              4. Then write your expressions. Enclose the expressions you want in the first stack inside if(flag=1,<expr>,0) and the ones in the second stack inside if(flag=2,<expr>).

               

              This should work. If not, please share a small sample of your qvw (with data sample in case of external load) so that we can use your data itself while resolving your issue.

              Regards

              Sid