topic Re: Drilldown with different expressions on each click in QlikView

Drilldown with different expressions on each click

Wed, 14 Nov 2012 15:59:19 GMT

Hi there,

I am brand new to QlikView and was hoping that someone would be able to help me on the following issue:

I've started building a chart to show the following information as stacked bars:

Scheduled Loss with expression SUM([Loss A]) + SUM ([Loss B])

Unplanned Loss SUM([Loss C]) + SUM([Loss D])

Net Production with expression SUM([Net Production])

for each type of Equipment (the dimension)

Now, I want to be able to drilldown such that if I click on Scheduled Loss for Equipment 1,

I get a breakdown of the types of losses ie

Loss A with expression SUM([Loss A])

Loss B with SUM([Loss B])

for Equipment A.

Similarly, I aim to get such a breakdown for when I click and drilldown on Unplanned Loss.

I have tried to use a cyclic group for sub-categories of Losses (A, B, C and D) and add that as a dimension after Equiment. I have also tried grouping expression from the first level together and from the second level together. The result just looks very messed up.

Any thoughts or suggestions would be very welcome

Re: Drilldown with different expressions on each click

whiteline — Wed, 14 Nov 2012 17:33:40 GMT

Hi.

You could use the conditional show feature for expressions. (QV 11)

Just add your expressions for each level.

Then add conditions. For example, you could check selections for some fields and so on.

Re: Drilldown with different expressions on each click

Wed, 14 Nov 2012 21:35:36 GMT

Hi Whiteline,

Thanks a lot for your reply.

I was wondering whether you could give me more guidance on how to do this...

I know it involves setting variables and using conditionals, but have very little clue on how to actually proceed.

Thanks so much,

Re: Drilldown with different expressions on each click

whiteline — Fri, 16 Nov 2012 17:33:52 GMT

Assume, that you have two dimensions: Dim1 and Dim2.

Lets name the drill-down group of them as GroupDim.

Then you could create a chart with GroupDim as dimension and Sum(Value) and Count(Value) as Expressions.

Now to show the first one for Dim1 and second one for Dim2 let's add conditional expression for each of them.

Toggle checkbox 'Conditional' and type expressions correspondingly:

=GetCurrentField(GroupDim)='Dim1'

=GetCurrentField(GroupDim)='Dim2'