Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering on expression - possibilities.

Hello,

I have a data like this:

ScreenShot001.png

Based on this table we are creating pivot table:

ScreenShot002.png

Is there a way to force a filter being set depending which value is clicked?

For example:

- User is clicking 6311 Value (in expression named Max), which will by default mark Bike in Vehicle Type.

Can we force setting different filter also? Like Brand - Romet for example (or any other). Some clever trigger usage maybe?

If not can we at least save expression name to variable somehow?

Example:

User clicked 6311 -> value Bike is stored to vExpression Name variable...

BR,

Kuba

1 Reply
Gysbert_Wassenaar

If you click on a value of an expression then the dimension values of the same row are selected. You could use the OnSelect field trigger of the Vehicle Type field to execute a Set Variable action. Or you could simply define the variable as =GetFieldSelections([Vehicle Type],',',999). When you use the variable it will return the list of selected values of the Vehicle Type field.


talk is cheap, supply exceeds demand