topic Re: Trouble using set analysis in a calculated dimension in QlikView

Trouble using set analysis in a calculated dimension

Anonymous — Wed, 12 Aug 2015 14:43:57 GMT

Hello,

I'm trying to use set analysis within calculated dimensions in a pivot chart to get group descriptions, however they keep coming back with errors.

Here is an example of one of my calculated dimensions

=Only({<Category = {'Group1'}>} Description)

In another dimension I'll have this:

=Only({<Category = {'Group2'}>} Description)

If I use the IF function, I seem to get what I'm looking for, but I've been told it's not best practice to use if statements within calculated dimension.

Re: Trouble using set analysis in a calculated dimension

Qrishna — Wed, 12 Aug 2015 14:49:09 GMT

Did you aggregate with respect to the other dimensions used in the chart/

Try:

AGGR( Only({<Category = {'Group1'}>} Description) ,ChartDimension2,ChartDimension3)

Other expr:

AGGR( Only({<Category = {'Group2'}>} Description) ,ChartDimension2,ChartDimension3)

Re: Trouble using set analysis in a calculated dimension

Anonymous — Wed, 12 Aug 2015 15:01:57 GMT

This is what I was missing. I didn't know that I had to use aggregation with respect to all the other dimensions in the chart.

Thank you Krishna.

Re: Trouble using set analysis in a calculated dimension

Qrishna — Wed, 12 Aug 2015 15:04:12 GMT

Awesome.

Happy Qliking