topic Re: Need help with Set Modifiers in QlikView

Need help with Set Modifiers

vvira1316 — Fri, 28 Mar 2014 14:08:49 GMT

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.

Re: Need help with Set Modifiers

vvira1316 — Fri, 28 Mar 2014 14:37:54 GMT

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)

Re: Need help with Set Modifiers

maxgro — Sat, 29 Mar 2014 11:16:01 GMT

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)

Re: Need help with Set Modifiers

vvira1316 — Mon, 31 Mar 2014 18:00:29 GMT

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

Re: Need help with Set Modifiers

maxgro — Mon, 31 Mar 2014 18:21:46 GMT

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.