4 Replies Latest reply: Jul 13, 2010 9:55 AM by amitgoenka RSS

    Drill down in QlikView

    amitgoenka

      <body><p>Hi,</p> <p>Am relatively new to QlikView and hence my query may be a repost.  This is related to slicing and dicing of data, typically done through an OLAP cube. </p> <p>I am pasting a sample of the data table below:</p> <p> </p> <table style="border-collapse: collapse; height: 184px;" border="0" cellpadding="0" cellspacing="0" width="480"> <p><col style="width: 77pt;" width="103"></col> <col style="width: 87pt;" width="116"></col> <col style="width: 99pt;" width="132"></col> <col style="width: 97pt;" width="129"></col> <tbody> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 77pt;" width="103" height="20"><b>SubscriberType</b></td> <td class="xl65" style="width: 87pt;" width="116"><b>SubscriberRegion</b></td> <td class="xl65" style="width: 99pt;" width="132"><b>Revenue</b></td> <td class="xl65" style="width: 97pt;" width="129"><b>SubscriberRatePlan</b></td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Corporate</td> <td class="xl66">North</td> <td class="xl66">150</td> <td class="xl66">Rate Plan A</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Corporate</td> <td class="xl66">South</td> <td class="xl66">110</td> <td class="xl66">Rate Plan B</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Non-Corporate</td> <td class="xl66">North</td> <td class="xl66">120</td> <td class="xl66">Rate Plan C</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Non-Corporate</td> <td class="xl66">South</td> <td class="xl66">100</td> <td class="xl66">Rate Plan A</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Non-Corporate</td> <td class="xl66">East</td> <td class="xl66">120</td> <td class="xl66">Rate Plan B</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Prepaid</td> <td class="xl66">North</td> <td class="xl66">40</td> <td class="xl66">Rate Plan C</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Prepaid</td> <td class="xl66">South</td> <td class="xl66">40</td> <td class="xl66">Rate Plan A</td> </tr> </tbody> </p> <p> </p> </table> <p>I need a chart (bar,pie, any type) which shows a sum(revenue) by subscriber type So, it should show </p> <p>Corporate - 260</p> <p>Non-Corporate - 340</p> <p>Prepaid - 80</p> <p> </p> <p>Now, there should be some means of changing the dimension to region, and now the graph should show me</p> <p>North - 310</p> <p>South - 250</p> <p>East - 120</p> <p>So, this breakup (or drill down) ignores the first dimensional break up altogether. </p> <p> </p> <p>One way of achieving this could be through drill down groups, but then the path is pre-defined. </p> <p> </p> <p>In OLAP-speak, my requirement is viewing a cube through a different set of dimensions.Effectively, I am changing the group by clause and summing up the revenues. </p> <p> </p> <p>How do I achieve this in QlikView?</p> <p> </p> <p>Thanks</p> <p>Amit</p> <p> </p></body>