topic Using variables within set analysis in QlikView

Using variables within set analysis

Fri, 18 Mar 2011 02:26:40 GMT

We currently use set analysis to de-select the values on a number of fields. Ex: Sum ({$<[Child Bskt Id]=,[Child Bskt Nm]=>} [Parent Rev]). We also need to force a selection on another field dynamically using a variable. The formula for this would be: Sum ({$(vTestgroup)} [Parent Rev]). We need to figure out a way to combine both formulas into one. We've tried multiple variations of this formula - such as: Sum ({$<[Child Bskt Id]=,[Child Bskt Nm]=>,$(vTestgroup)} [Parent Rev]). Nothing we have tried has worked. Any help on this would be much appreciated.

Using variables within set analysis

jonathandienst — Fri, 18 Mar 2011 05:54:50 GMT

The first thing to try is to put the closing angle bracket in the right place:

Sum ({$<[Child Bskt Id]=,[Child Bskt Nm]=,$(vTestgroup)>} [Parent Rev])

If that still does not work, then I suggest you provide more information about what the variable vTestGroup contains. Looking at your example in the post, it looks like vTestGroup contains angle brackets. Remove them and try the expression above.

Hope that helps
Jonathan

Using variables within set analysis

Fri, 18 Mar 2011 12:17:22 GMT

Thanks for helping us out with this, Jonathan. Moving the angle bracket didn't work either and was actually just a mistake on my part in the post. The variable vTestgroup is actually keyed off of a bookmark. vTestgroup = BM19. BM19 is set using an action button - the end result is always a series of selections on a single field [Location].

Thanks,

Travis

Using variables within set analysis

jonathandienst — Fri, 18 Mar 2011 12:29:03 GMT

Travis

To use a bookmark, it goes in the place of the $ sysmbol:

Sum ({BM19<[Child Bskt Id]=,[Child Bskt Nm]=>} [Parent Rev])

So if vTestGroup = BM19, should be:

Sum ({$(vTestGroup)<[Child Bskt Id]=,[Child Bskt Nm]=>} [Parent Rev])

Jonathan

Using variables within set analysis

tduarte — Fri, 08 Jul 2011 15:44:18 GMT

Travis, that isn't working for me.

I'm using a simple Concat ({$(vBookmark)} field_name) and it doesn't return anything. If I replace $(vBookmark) by the bookmark name then it works fine.

Is there something wrong with the syntax or is it just not possible to use bookmarks inside variables?

Thanks,

Telmo