Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Filtering on expression - possibilities.

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