topic Re: using variable and text in set analysis in QlikView

using variable and text in set analysis

chrismtb — Fri, 05 Nov 2021 11:10:20 GMT

Hi further to a previous post i am using set analysis to dispay one value in a text box.

My simplified data is as below:

ID	Area	Manager	Status
Backlog1	Northwest	Jenny	Active
Backlog2	Northeast	Steve	Closed
Backlog3	Southwest	Mike	Active
InProgress1	Southeast	Carol	Closed

I am using =Only({$<ID={Backlog1}>} Area) to display in a text box the Area related to the first ID and another for the second and so on.

What i want to do is make the ID in the set analysis a variable (so that i can set some record set selection buttons up)... I assume that i can do this with a straight variable - i.e. a variable with a value of "Backlog1" (or "backlog"& number) however is there a way for me to do that within the formula itself.

To put another way is it possible to create a set analysis that has a string concatenation like this =Only({$<ID={"Backlog"&vNum}>} Area) combining the word backlog and the variable number?

As always looking forward to suggestions!

Thanks

Chris

Re: using variable and text in set analysis

rbartley — Fri, 05 Nov 2021 11:44:43 GMT

Hi Chris,

Is there any reason why you wouldn't just create a variable that contained the full text, e.g. Backlog1, Backlog 2, etc.? Concatenating within a set analysis expression, whether possible or not, will make your expression less readable.

Re: using variable and text in set analysis

chrismtb — Fri, 05 Nov 2021 12:01:09 GMT

Hi,

Partly curiosity to see what the art of the possible is, but also scaleabilty - if i have say 10 IDs for "backlog" i also have items for 5 other catagories that I would be looking to do the same for (e.g. InProgress1 from the example above)...

therefore if i held the full text in the variable i would require variables for 10 items x 6 catagories = 60 variables.

If i can do it within the formula i can hold just the numbers in the variables and amend the formula for the catagories... that way i would only hold 10 variables.

Thanks

Chris