topic Re: match values within a variable in QlikView

match values within a variable

Anonymous — Wed, 15 Mar 2017 19:18:59 GMT

Hello,

I'm wondering how I can place multiple text values within a variable and, if a selected dimension value matches one of the values in the variable, activate a button.

The variable contains comma separated values and I'm trying to say that when a selected value in a dimension = a value in the variable, show 1, 0.

Something like this:

if(match(Getfieldselections(Dimension),Variable),1,0)

My variable is set like this in the script:

Set Variable = 'Text1','Text2','Text3';

Any suggestions?

Re: match values within a variable

sunny_talwar — Wed, 15 Mar 2017 19:37:53 GMT

Try this:

Max(Aggr(If(SubStringCount(Variable, Dimension) >= 1, 1, 0), Dimension))

Re: match values within a variable

sunny_talwar — Wed, 15 Mar 2017 19:38:14 GMT

Sample attached

Re: match values within a variable

sunny_talwar — Wed, 15 Mar 2017 19:44:16 GMT

Or this if the button should be hidden when not selection in Dimension is made

Max(Aggr(If(SubStringCount(Variable, Dimension) >= 1, 1, 0), Dimension)) and GetSelectedCount(Dimension) > 0

Re: match values within a variable

vishsaggi — Wed, 15 Mar 2017 19:56:43 GMT

Sunny, why we need Max(Aggr()) cant we just use

like in layout conditional

= vVar = If(SubStringCount(Variable, Dimension) >= 1, 1, 0) ??

Re: match values within a variable

sunny_talwar — Wed, 15 Mar 2017 20:42:23 GMT

If this need to work only based on a single selection, then without Max and Aggr() will work... but in case we need this to work based on multiple selection, then without Max and Aggr() it will not work....

Re: match values within a variable

vishsaggi — Wed, 15 Mar 2017 20:48:54 GMT

Ah, Got it. Thanks for that.

Re: match values within a variable

Anonymous — Wed, 15 Mar 2017 20:59:52 GMT

Thank you both for the responses! I only needed it to be based on a single selection and it's working without the max and aggr.

Re: match values within a variable

vishsaggi — Wed, 15 Mar 2017 21:01:00 GMT

David, by mistake you have made my response as correct. I did not give that solution, i got that from Sunny. I have just asked that question to him.

Re: match values within a variable

vishsaggi — Wed, 15 Mar 2017 21:16:23 GMT

No harm, Even though you use them, it still works...So, i feel i should not be credited for this as i just copied from his expr.