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
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. 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?

389 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)

226 Views
0 Likes