Trouble using set analysis in a calculated dimension

[Anonymous]

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.

[krishna_2644 · Accepted solution]

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)

[Anonymous]

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.

[krishna_2644]

Awesome.

Happy Qliking