Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

 

 

 

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
Champion III
Champion III

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