topic Re: Dimension groups in a calculated dimension in QlikView

Dimension groups in a calculated dimension

Anonymous — Thu, 21 May 2015 14:09:31 GMT

Hey

Is it possible to use dimension Groups in a calculated dimension?

I want to calculate a dimension where I use dimensiongroup1 if the variable var1 = 1 and dimensiongroup2 if var1 = 2.

But when I try to set this calculated dimension up in a bar chart, I can only choose fields inside this IF statement, and not any dimension Groups I may have specified.

=if(var1 = 1,DimensionGroup1, If(var1 = 2, DimensionGroup2))

Are there anyone who can help with this?

/Michael

Re: Dimension groups in a calculated dimension

JonnyPoole — Thu, 21 May 2015 14:18:10 GMT

You can . But wrap the group names in [] brackets.

=if(var1 = 1,[DimensionGroup1], If(var1 = 2, [DimensionGroup2]))

Also test with $(var1) ... dollar sign expansion if you aren't getting the desired results.

Alternatively, you could also add both groups to the dimensions and do a conditional show/hide on each dimension so that only 1 is used conditionally

Re: Dimension groups in a calculated dimension

sunny_talwar — Thu, 21 May 2015 14:19:10 GMT

I guess you mean cycle or drill down groups when you say "dimension group"? If yes, then you might be able to do what you have listed or you can add both your groups as dimension and make them condition.

for DimensionGroup1 use the condition var1 = 1 and

for DimesnionGroup2 use the condition var1 =2

I hope this helps.

Best,

Sunny

Re: Dimension groups in a calculated dimension

Anonymous — Thu, 21 May 2015 14:24:31 GMT

Cool, thanks alot. I will go for the show/hide option.

Best,

Michael