Drill down in QlikView

Anonymous — Tue, 13 Jul 2010 12:04:57 GMT

<body>Hi, 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. I am pasting a sample of the data table below: <table style="border-collapse: collapse; height: 184px;" border="0" cellpadding="0" cellspacing="0" width="480"> <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">SubscriberType</td> <td class="xl65" style="width: 87pt;" width="116">SubscriberRegion</td> <td class="xl65" style="width: 99pt;" width="132">Revenue</td> <td class="xl65" style="width: 97pt;" width="129">SubscriberRatePlan</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> </table> I need a chart (bar,pie, any type) which shows a sum(revenue) by subscriber type So, it should show Corporate - 260 Non-Corporate - 340 Prepaid - 80 Now, there should be some means of changing the dimension to region, and now the graph should show me North - 310 South - 250 East - 120 So, this breakup (or drill down) ignores the first dimensional break up altogether. One way of achieving this could be through drill down groups, but then the path is pre-defined. 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. How do I achieve this in QlikView? Thanks Amit </body>

Drill down in QlikView

kji — Tue, 13 Jul 2010 12:55:40 GMT

Define a cyclic group that you use as dimension, there is a button for edit groups on the dimension page of the chart properties, Since you are not talking about a hierarchy i assume you want cyclic group and not drilldown.

Drill down in QlikView

Tue, 13 Jul 2010 13:29:15 GMT

Hi Amit,

Plz refer to the attachment for solution.

I have defined Cyclic Group (Settings-Document Properties-Group-New) of Subscriber Type and Subscriber Region.

While creating chart, I have selected that group in dimension and expression as Sum(Revenue).

Hope this is what you need.

Sincere Regards,

RBA

Drill down in QlikView

Anonymous — Tue, 13 Jul 2010 13:48:36 GMT

Thanks Johan. This solves the earlier requirement.

I also tried adding both a cyclic group and a drill down group as dimensions to a chart, and found interesting results.

Drill down in QlikView

Anonymous — Tue, 13 Jul 2010 13:55:00 GMT

Thanks Ravi.

topic Drill down in QlikView in QlikView

Drill down in QlikView

Drill down in QlikView

Drill down in QlikView

Drill down in QlikView

Drill down in QlikView