Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drilldown with different expressions on each click

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

3 Replies
whiteline
Master II
Master II

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.

Not applicable
Author

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,

A

whiteline
Master II
Master II

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'