Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2013-05-01 04:15 PM

Alternate State

I have a pivot table with:

Dim = Image

Exp1 = Retailer

Exp2 = Prod

Exp3 = Price

I need to connect one selection box that has retailer values connect to this pivot table only. I'm thiniking Alternate State butI do not have Sum, Count or any other Aggregate function in my expressions, they all are simply field names.

Is it still possible to use Alternate State or is there any other way of achieving the same?

385 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2013-05-01 05:59 PM
Author

I used Only and it seems to work:

Only({AltState}Retailer)

222 Views
0 Likes