topic Re: Set Analysis: How to combine a variable or column with wildcard in QlikView

Set Analysis: How to combine a variable or column with wildcard

Thu, 05 Mar 2015 23:02:45 GMT

Hi,

How can I I combine a variable or column with the wild card in set analysis:

Something like this with variable:

sum({$<HID= {$(vHID & '*')}>} Amount)

Or like this syntax with a column:

sum({$<HID= {$(HID & '*')}>} Amount)

Thanks!

maxgro — Thu, 05 Mar 2015 23:09:51 GMT

=sum( {$<HID={"$(HID)*"}>} Amount )

Thu, 05 Mar 2015 23:20:27 GMT

And in case I wanna use the variable I just need to replace the field with the variable (vHID) and it should work, right?

=sum( {$<HID={"$(vHID)*"}>} Amount )

maxgro — Thu, 05 Mar 2015 23:22:13 GMT

yes I forgot the v