Need help with Set Modifiers

[vvira1316]

Hi,

I've situation where I've to modify the set based on two input values that defines range for a field. All records within those limits have to be part of modified set.

If I'm hardcoding values (one value, two values) then my expression provides the result that I'm looking for but it is not working even with one variable.

I'm referring following video link that explains how to work with set modifiers etc. In the video there is a similar example.

Qlikview Set Analysis: Basics « Learn Qlikview

Sum({<hh_index = {'116.00'}>} dollar_sales_total)

Sum({<hh_index = {'116.00', '165.00'}>} dollar_sales_total)

Sum({$<hh_index = {'<=(=vHHIndex_UB)'}>} dollar_sales_total)

screen shot for expression using variables defined below. As can be seen Sales is 0 for each.

[vvira1316]

Hi,

I found my mistake. I got it working with one variable but still it is not work with two variables. Any help/ideas/suggestions will be very helpful.

Sum({$<hh_index = {'<=$(=vHHIndex_UB)'}>} dollar_sales_total)

This is working

Sum({$<hh_index = {'<=$(=vHHIndex_UB) ', ' >=$(=vHHIndex_LB)'}>} dollar_sales_total)

Is not working

Sum({$<hh_index = {'<=$(=vHHIndex_UB) and >=$(=vHHIndex_LB)'}>} dollar_sales_total)

is not working

Please see screen shots below.

Screen shot with Sum({$<hh_index = {'<=$(=vHHIndex_UB)'}>} dollar_sales_total)

[maxgro]

sum({$ <hh_index={">=$(vHHIndex_LB)<=$(vHHIndex_UB)"}>} dollar_sales_total)

if you remove the label on expression

you can see ..... as in the image and it can help you

in my test data the expression is

sum({$ <Expression3={">=$(vmin)<=$(vmax)"}>} Expression1)

[vvira1316]

Hi,

Thanks for suggestion and reply. I'm on to different project so I won't be able to check it but I'm sure it is useful and have forwarded information to team.

Cheers,

Vijay

[maxgro]

Please close this discussion by giving Correct and Helpful answers to the posts (if any) which are useful for you.  It helps others in finding answers for similar scenarios. Regards.