Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two same dim + AS


Trying to make pivot table using two dimentions by X and by Y, but want to use same field in basic and alter state.

Basic state is simple, i just add dimention.

Alter state is: =AGGR(ONLY({AS1} MyDimention),MyDimention)

but when i select something at basic state it limits AS1 too, because it used at AGGR without alter state condition.

how can i make second dimention not limited by basic state selections?

2 Replies
Master II
Master II


The problem could be in the expression.

Not applicable


Can u pls share the sample app?

Thanks !!