12 Replies Latest reply: Dec 24, 2011 2:21 PM by Kent Shook RSS

    Making an "artificial" dimension selectable

    Kent Shook

      I have the need to show four bits of information which have flags in the data - Bold vs. Not Bold (in the BoldFlag field), Indented vs. Not Indented (ParentID exists or is null), and a couple of others.

       

      I started with a trellised pie chart, but a stacked bar chart would work too - I'm trying to avoid four separate charts due to screen space limitations. I started with an "artificial" dimension - I enumerated the names of the four properties with a ValueList.  Then, I wrote expressions for "used" and "not used" that test for each of the four properties. Unfortunately, this doesn't allow selections to be made by clicking on the chart.

       

      I've thought through different ways of doing this with some assistance from others, but we haven't yet figured out a way to both have the four separate items in one chart AND make them click-selectable. Any ideas?

        • Making an "artificial" dimension selectable
          Karl Pover

          Instead of a valuelist you can also use a island table with the artifical dimensions and those are selectable.

           

          Karl

            • Making an "artificial" dimension selectable
              Kent Shook

              So, in your island table you'd simply have a single field with a record with the name of each of the four bits of information?

               

              I should clarify that the client wants to see the relationship between all four of these flags, so they do need to associate. I had considered a separate table with one record for each of the four attributes, but the problem is that if you select "Not used" on one of the attributes, it would select not used on ALL of the attributes, thus making a comparison impossible.

                • Making an "artificial" dimension selectable
                  Karl Pover

                  I don't know if I completely understand the whole situation, but I was thinking more about having 4 separate table islands with flags that you can use to control the expressions with sum(if()) or sum($(variableDefinedByFlags)), but if you could upload an example or post an image, I might get a better idea of what you are looking for.

                   

                  Karl

                    • Re: Making an "artificial" dimension selectable
                      Kent Shook

                      Here's an example, with a couple of different charts working a couple of different ways - What I want is for the user to be able to click on, for example, the Used part of Flag1 and see what the proportion of the other flags being used is for those records where flag1 is used.

                        • Making an "artificial" dimension selectable
                          Karl Pover

                          I don't see the example.

                            • Re: Making an "artificial" dimension selectable
                              Kent Shook

                              Whoops - Attachment fail. It's there now.

                                • Re: Making an "artificial" dimension selectable
                                  Karl Pover

                                  Is this what you are looking for?

                                   

                                  Karl

                                    • Re: Making an "artificial" dimension selectable
                                      Kent Shook

                                      Not quite - The problem with doing it that way is that when you click on the graph to select "Used" for example, it selects "Used" on all four attributes. What we need to do is select "Used" on one flag, for example, and see the proportions that are *and aren't* used on the remaining flags.

                                       

                                      So, for example, click in the left-hand table box to select Flag1=1, and you'll see all of the graphs do exactly what we want them to.

                                        • Making an "artificial" dimension selectable
                                          Karl Pover

                                          Since you can only filter by dimension when selecting in a chart, you would have to have the concept and the flag be a dimension.  It's easy to do as different charts, but making it 1 chart is the difficult part that I haven't figured out yet. At some point in the future in QV 11, you could put the four separate charts in a grid container. 

                                           

                                          For now maybe somebody else has an idea.

                                           

                                          Karl

                                            • Re: Making an "artificial" dimension selectable
                                              Kent Shook

                                              Karl,

                                               

                                              We're actually using QlikView 11 on this project - Part of the reason for the screen space limitation is that this chart is already inside a 3x3 grid container that's inside a regular container. However, maybe another 2x2 grid container with 4 separate charts and all of the captions/borders/shadows/etc. removed would display reasonably well - I'll give that a shot.

                                               

                                              Thanks,

                                               

                                              Kent

                                                • Re: Making an "artificial" dimension selectable
                                                  Karl Pover

                                                  Kent,

                                                   

                                                  I liked the kind of analysis you were trying to do and I was motivated to think about different ways to show this type of binary basket analysis, so I've included a couple examples you can use to analysis this information in a tight space without the user even making one click.

                                                   

                                                  The graph reads across that when Flag1 is used there is a 100% chance Flag1 is used, about a 45% chance Flag2 is used,  about a 50% chance Flag3 is used and about a 60% chance Flag4 is used.  Then when Flag1 is not used there is a 0% chance Flag1 is used, about a 30% chance Flag2 is used, about a 40% chance Flag3 is used and about a 58% chance Flag4 is used.

                                                   

                                                  In general, in either of these 2 graphs below you can see that whether they use Flag1 has a higher influence if they are going to use or not use Flag2 or Flag3.  On the other hand whether they use or not Flag4 has little influence whether they use or not all the other flags. 

                                                   

                                                  The QV app is attached if you are interested.

                                                   

                                                  Karl

                                                   

                                                  Bars.JPG

                                                   

                                                  pies.JPG

                                                    • Re: Making an "artificial" dimension selectable
                                                      Kent Shook

                                                      Thanks Karl, that's an interesting solution! We might have to make use of that.

                                                       

                                                      There's also a "social engineering" aspect to this - With what the client initially asked for, it made more sense to group the four flags into sixteen buckets that were named appropriately. (Actually, it was somewhat fewer than sixteen, since when some of the flags are true, some of the others don't matter.) But I think they were wowed with the "qlikability" of things, and insisted they wanted it this way. I think that once this app is done and they start looking at things, they'll appreciate that it's better to have a good visualization that doesn't require clicking. At that point, what I'd really like to do is use the new Venn diagrams in QlikView 11. So, we'll see what happens.

                                                       

                                                      Thanks for all your help!

                                                       

                                                      Kent