6 Replies Latest reply: Nov 4, 2011 3:32 AM by Claudia Zwick RSS

    Stack(Group)Problem in Bar Chart

      Hi All:

       

      I have a question of the stack(group) issue in bar chart. The problem is that currently, i have 4 bar, which are Inflow(Operating), inflow(Financial), outflow(Operating) and Outflow(Financial) and the dimentsion is Month. Now, i'd like to stack the two expression of Inflow(Operating and Financial) and Stack two expression of Outflow too, and then group the two stackted bar. So, finanlly, there are two stacked bar for each month, Inflow and Outflow respectively. And in each bar, they are divideded into operating and Financial. Does it works in QV?

       

      Thanks

      Stefanie

        • Stack(Group)Problem in Bar Chart

          Hi Stefanie,

           

          I have solve such a similary problem with joining and flagging the data in the script.

          Something like:

           

          LOAD

               month,

               value,

               'inflow' AS flag1,

               'operating' AS flag2

               RESIDENT table

               where value_type = inflow_operating;

          JOIN LOAD

               month,

               value,

               'inflow' AS flag1,

               'financial' AS flag2

               RESIDENT table

               where value_type = inflow_financial;

          JOIN LOAD

               month,

               value,

               'outflow' AS flag1,

               'operation' AS flag2

               RESIDENT table

               where value_type = outflow_operation;

          JOIN LOAD

               month,

               value,

               'outflow' AS flag1,

               'financial' AS flag2

               RESIDENT table

               where value_type = outflow_financial;

           

          In the bar chart you have the dimensions: month, flag1, flag2 and the expression is sum(value).

          In the tab "design" you have to check stacked.

           

           

          Regards vicky

            • Re: Stack(Group)Problem in Bar Chart

              Hi Vicky:

               

              really appreciate for your answer, but after i tried your script, the system indicate there are some errors in it. so, i have uploaded the qv file and excel file and hope that you can illustrate the method in qlikview, many thanks to your help!!!!!

                • Re: Stack(Group)Problem in Bar Chart

                  Hi Stefanie,

                   

                  I have done it You only have to comment your "table" in and my table out, so you can see the result. I hope, you can change it to your data.

                   

                  Have a nice day!

                   

                  Vicky

                    • Re: Stack(Group)Problem in Bar Chart

                      Vicky!!! many thanks to your help!!!!

                       

                      Have a nice day~!

                      • Re: Stack(Group)Problem in Bar Chart

                        Hi Vicky,

                         

                        Here also some errors, when i put the following script in, the system always indicate is can't find them:

                        LOAD

                             month,

                             value,

                             'inflow' AS flag1,

                             'operating' AS flag2

                             RESIDENT table

                             where value_type = inflow_operating;

                        JOIN LOAD

                             month,

                             value,

                             'inflow' AS flag1,

                             'financial' AS flag2

                             RESIDENT table

                             where value_type = inflow_financial;

                        JOIN LOAD

                             month,

                             value,

                             'outflow' AS flag1,

                             'operation' AS flag2

                             RESIDENT table

                             where value_type = outflow_operation;

                        JOIN LOAD

                             month,

                             value,

                             'outflow' AS flag1,

                             'financial' AS flag2

                             RESIDENT table

                             where value_type = outflow_financial;

                         

                        what's wrong with the script?

                          • Stack(Group)Problem in Bar Chart

                            Hi Stefanie,

                             

                            This script was only an example without having real field names. Use the script of the qvw in my last post, that's with your real names.

                             

                            Before seeing your script, it was hard to know your datas. In our table there are your Inflow Operation, Inflow Finance, Outflow Operation and Outflow Finance all individual fields. In my case there is only one field for the value and one field that indicates the value. I think the where-clause doesn't work, because you haven't got a field with the four value_types.

                            And maybe your table name is another then "table".

                             

                            Regards vicky