5 Replies Latest reply: Apr 30, 2013 3:30 AM by Friedrich Hofmann RSS

    Table object with drilldown and a twist in the dimension

    Friedrich Hofmann

      Hi,

       

      the situation is this: I am putting together a QlikView document and I have a ppt presentation that's been negotiated with management about how it should look, so now I have to get my document to look like that. There is a table with a drilldown dimension (turnover values per date-PartnerType-Model-Division...) AND there are the volume figures - these are actually a value that every record has, so they actually belong to the y-axis of the diagram- but acc. to the presentation, they should be in a row, not in a column. I attach a dummy slide so you can see how I have to make it look.

      I solved this by adding a row of textboxes below the diagram with formulas in the textboxes to display the overall volume figures - but I need this only on the topmost level. In principle, one can drill down into the volume figures just like the turnover figures.

      So as soon as the "volume" button has been pressed (equivalent of clicking one of the dimension values),

      - a textbox showing the next_upper_level (within the drilldown group) should then read "Volume"

      - the formulas should all change to display volume figures rather than turnover figures;

      - the row of textboxes at the bottom should disappear.

      I hope I have described precisely enough exactly what I am trying to do and someone can give me a hint about how to achieve that. If my description is in any way unclear, please tell me so and I'll try my best to make it more precise. The hurdle I have to overcome is actually "merely" to identify when the user has clicked on that textbox reading "Volume". The rest is additional IF clauses that I can build into all the formulas and stuff.

      Thanks a lot!

      Best regards,

       

      DataNibbler

        • Re: Table object with drilldown and a twist in the dimension
          Mike Hennigan

          You could create a table (tblVolume) with one Field called Volume and the data contained in that file will be Volume.  Something like:

           

          tblVolume:

          LOAD * INLINE [

               Volume

                   Volume

          ]
          ;

           

          You could then use a List Box instead of a Text Box.  If you do some formatting like hiding the Caption you might be able to make it look like a Text Box.  By setting it up like this, you will be able to use triggers and functions like GetFieldSelections to determine if the user has clicked on the Volume text/list box.

           

          I hope this helps!

           

            • Re: Table object with drilldown and a twist in the dimension
              Friedrich Hofmann

              Hi mphekin,

               

              thanks for helping! I think I have thought of a possible way myself, I guess none is faster than the other since I need that only on the uppermost level, as soon as the user drills down, I can use the diagram I have, only with different formulas.

              I can create a variable (like >v_show_volume< and initially set it to 'N'. I can then add a trigger to that "volume" textbox to change that to 'Y'

              => I can query that variable in the formulas of my diagram to calculate either of two formulas, turnover or volume.

               

              <=> The textbox I have always displaying the next_level_up in the drilldown group must then show "volume" instead of "variable turnover" as the uppermost level - which is probably a bit tricky because "volume" is not a dimension where I can make any sensible selection, every record has a volume, so I cannot easily make it part of my drilldown group.

               

              <=> I also have to find some way to reset the variable to 'N' when the user drills back up to the uppermost level (that is, the "fixed/ variable/ specials" level, the turnover types of which I currently only have variable.)

               

              Can anybody advise me in any way on how to do this?

              Thank you very much!

              Best regards,

               

              DataNibbler

                • Re: Table object with drilldown and a twist in the dimension
                  Friedrich Hofmann

                  Hi,

                   

                  I guess I can do it that way, with a variable. As for resetting it, I can just create another button that the user has to press once they have drilled back up and want to see the turnover figures again. I can even make that appear only when the uppermost level within my drilldown group is active, can't I?

                  I'd still be thankful if anybody could show me a better way, but that will do nicely.

                  Then I have to build a query in my "show_next_upper_level" textbox to query if

                       - the variable has a certain value

                       - and the currently active dimension is "Turnover_Type" (so I'm on the uppermost level)

                          => in which case I will have that just display the fixed text "Volume".

                  The formulas in themselves are not problematic, I can query the variable to choose between two formulas.

                   

                  My question for the moment is: Can I implement a "toggle switch" for a variable (to set the variable from the initial state 'N' to 'Y' upon clicking and back to 'N' with another click?

                   

                  Thanks!

                  Best regards,

                   

                  DataNibbler

                    • Re: Table object with drilldown and a twist in the dimension
                      Mike Hennigan

                      Open the Properties for the button and go to the Action tab.  Click on the Add button and select Set Variable under the External Action Type.  Type the variable name in the Variable text field and something like

                      = if(vVariableName='Y','N','Y')

                       

                      in the Value text field.

                       

                      I hope this helps!

                       

                        • Re: Table object with drilldown and a twist in the dimension
                          Friedrich Hofmann

                          Hi mphekin,

                           

                          yes, that might work.

                          Maybe, however, I can solve this situation another way: I will enter a proposal with management - something I did not think I could, but I learnt yesterday that I can - to display the volume_figures on the y-axis from the beginning. That would make the whole thing a lot easier and I wouldn't have to bother about all this.

                          An annoying thing that I didn't think of this long ago, but how was I to know...

                          I will try, but I will keep your proposal in mind anyway. I'm sure I can use it eventually.

                          Thanks a lot!

                          Best regards,

                           

                          DataNibbler