topic Re: How to use Calculated Dimensions in set analysis in QlikView

How to use Calculated Dimensions in set analysis

vishus913 — Tue, 23 Oct 2018 12:52:24 GMT

Hi All,

Can we use calculated dimensions in set analysis?

Re: How to use Calculated Dimensions in set analysis

sunny_talwar — Tue, 23 Oct 2018 13:00:39 GMT

What exactly are you trying to do? Would you be able to elaborate with an example?

Re: How to use Calculated Dimensions in set analysis

kingsleyh — Tue, 23 Oct 2018 13:01:17 GMT

Hi Vikas.

I think it depends on the Calc you are trying to do.

Something like the following will work:

SUM({<Year={$(=Max(Year)}>} Sales)

Many thanks

Kingsley

Re: How to use Calculated Dimensions in set analysis

vishus913 — Tue, 23 Oct 2018 13:19:34 GMT

I have Year as a dimension and a calculated dimension which has 'cohort participant' and 'non cohort participant', and there is a single measure for them, now for each year i want to show two measures one for the 'cohort participant' and one for the 'non cohort participant' corresponding to each year.
but i can not apply conditions in set analysis on this calculated dimension. Is there a way i can do so

Re: How to use Calculated Dimensions in set analysis

kingsleyh — Tue, 23 Oct 2018 13:24:24 GMT

Hi.

Please can you show me your calculation.

Sounds like you need AGGR()

Re: How to use Calculated Dimensions in set analysis

sunny_talwar — Tue, 23 Oct 2018 13:28:12 GMT

From what you are saying, it should be possible, but I am not sure what you have to give you the exact syntax