topic Re: calculated dimension in QlikView

calculated dimension

Anonymous — Thu, 11 Feb 2016 16:37:59 GMT

I need to create a calculated dimension for a chart which disregards the current selection in the Field 'Wave'.

I try: =Aggr(Only({<Wave=>}Wave), Wave)

But it doesn't work. It does not disregard the current selection in the Field 'Wave'.

Could you, please, give me a prompt?

Thank you in advance,

Larisa

Re: calculated dimension

sunny_talwar — Thu, 11 Feb 2016 16:40:19 GMT

I think instead of adding it to your dimension, I would add this to all my expressions:

{<Wave=>}

Re: calculated dimension

Anonymous — Thu, 11 Feb 2016 16:46:48 GMT

It's a nice idea. But the Expressions (there are 20 different ones which get activated on a certain condition) are based on Variables which I don't want to change.

So, is it possible to set a calculated dimension?

Re: calculated dimension

rwunderlich — Thu, 11 Feb 2016 19:00:23 GMT

Aggr(Only(1}Wave), Wave)

It will still get filtered by the Expressions, so may not give you what you expect.

-Rob

Re: calculated dimension

satishkurra — Thu, 11 Feb 2016 19:05:11 GMT

Correcting Rob's expression.

Just a type

Aggr(Only({1}Wave), Wave)

Rob: Apologies if anything wrong...

Thanks

Satish

Re: calculated dimension

Anonymous — Fri, 12 Feb 2016 09:30:26 GMT

Thanks, everyone, for your comments!