Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Selection of Calculated Dimension

HI All

I need help is making selections in a calculated dimension, it goes something like this.

Calc Dim = If(Dim3='A',Dim1, Dim2)

This is a part of my table. If someone makes a selection in this dimension, then all 3 dimension get selected but I want either Dim1 or Dim2 to select and not the others. Is this possible?

 

Regards

Pratyush

1 Reply
Highlighted
MVP
MVP

Re: Selection of Calculated Dimension

When you make a selection from a calculated dimension, you are actually making a selection in the underlying fields. Much the same way as selecting an expression value in a straight table selects the dimensions underlying the selected expression value.

If possible, use this logic to create a derived field in the load script.

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein