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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
DSDD
Contributor III
Contributor III

Filter values within a dimension?

Dear community,

i try to filter a dimension within a chart.

Lets say i want to count packages for weight classes in a bar chart.

Despite al lot of searching i did not find syntax to filter packages between 5 and 10 kilogram.

One of my attempts:

{<pack_max_weight={'<10'},pack_max_weight={'>5'}>}pack_max_weight

This filter shall lie beyond all other filters. That means the resulting set can be reduced even more by other filters.

Thank you in advance

 

 

 

Labels (2)
5 Replies
GaryGiles
Specialist
Specialist

The set analysis syntax would be:

{<pack_max_weight={">5<10"}>}

be sure to use double-quotes "

DSDD
Contributor III
Contributor III
Author

Dear Gary,

thanks for the hint. Thought it might help me to solve the actuall question, but it doesnt.

I want to have the upper and lower weight as a variable.

let say v_lower has the value 5 and v_upper the value 10. (Defined by a range slider)

I dont geht how to write the syntax having variables. I tried a lot of combinations with this f... syntax, none working.

Thanks for your very appreciated help

 

pradosh_thakur
Master II
Master II

{<pack_max_weight={">$(v_lower)<$(v_upper)"}>}

Learning never stops.
Chanty4u
MVP
MVP

try this

{<pack_max_weight={">$(=(v_lower))<$(=(v_upper))"}>}

 

DSDD
Contributor III
Contributor III
Author

why do you propose the syntax with equal-sign? In which cases is that used?

the version $(v_lower) works