Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Using alternate states in Dimensions

Hello,

How can you use alternate states in dimensions?

In a scatter plot i have 2 dimensions A and B, where B is an alternate state of A. How can i use an alternate state of A as a dimension in a chart?

Thanks in advance,

Regards

Tags (3)
3 Replies
apalmtree
Contributor II

Re: Using alternate states in Dimensions

did you get a soultion for this? i have a similar problem.

Not applicable

Re: Using alternate states in Dimensions

Nop. I had to change the database model. Try creating a copy of the table.

Not applicable

Re: Using alternate states in Dimensions

I got mine to work using the following:

=Aggr(Max({$<POSDate=P({[Alt Calendar]})>}POSDate),POSDate)

POSDate is my dimension, but it needed to be limited by my alternate state (Alt Calendar).