Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vishus913
Partner - Creator
Partner - Creator

How to use Calculated Dimensions in set analysis

Hi All,

Can we use calculated dimensions in  set analysis?

5 Replies
sunny_talwar

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

kingsleyh
Partner - Contributor II
Partner - Contributor II

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

vishus913
Partner - Creator
Partner - Creator
Author

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

kingsleyh
Partner - Contributor II
Partner - Contributor II

Hi.

Please can you show me your calculation.

Sounds like you need AGGR()

sunny_talwar

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