Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate state with Other Filterbox selction

Hi,

 

I’m trying to use Alternate State on Straight Table chart, but Straight table should also respond to other Lists boxes.

 

e.g.,

 

My Detail Straight table has Status Listbox (which is Alternate State) and this Straight table should also respond to other list boxes like Country, Month, etc.

  I have used non aggregated columns (Dimensions) in the Expression.

Please help!

Thank you

 

1 Solution

Accepted Solutions
sunny_talwar

Check the attached

Capture.PNG

View solution in original post

6 Replies
sunny_talwar

Would you be able to share a sample to show what you are trying to do?

Not applicable
Author

Hi, Thanks for the response.

Bottom right 'Dim1' has alternate state and linked with Table 2.

Table 2 is a Straight table with Dimensions as expression.

I'm expecting Table 2 should respond to Dim 1 (Alternate State) and also to Dim 3 (inherited)

AlternativeState.PNG

sunny_talwar

So for instance if you select X in Dim3 and A in Dim1, you would want to see only 1 row where Dim1 = A and Dim3 = X?

Not applicable
Author

Yes, if I select X in Dim3 and A in Dim1, you would want to see only 1 row where Dim1 = A and Dim3 = X

sunny_talwar

Check the attached

Capture.PNG

Not applicable
Author

Fantastic, Thank you so much!

Regards, Sri