topic Re: Alternate State Variable in Set Analysis in QlikView

Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 18:11:32 GMT

I have a simple expression like the following, but it doesn't work.

SUM({Benchmark<ProcGroup= {"$(eProcedureGroup)"}>}BMHCA1PCT)

The variable eProcedureGroup is created @ script load with the following: SET eProcedureGroup = 'GetFieldSelections(ProcGroup)';

I've tried the following as well:

SET eProcedureGroup = 'chr(34)&GetFieldSelections(ProcGroup)&chr(34)';

SET eProcedureGroup = 'chr(39)&GetFieldSelections(ProcGroup)&chr(39)';

When I view the variable in the same alternate state in a text box it gives me the selected ProcGroup from the alternate state 'Benchmark'.

I'm not sure why the variable is NOT working in the set analysis, but I think it has something to do with the Benchmark alternative state. It used to work with ProcGroup = {'Total Knee'}, but there has been additional services added to the data.

I have ProcGroup which is a listbox filter on the alternate state Benchmark. All the data on this tab uses the Benchmark alternate state. Any ideas?

Re: Alternate State Variable in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 18:20:38 GMT

How about this:

LET eProcedureGroup = GetFieldSelections(Chr(39) & ProcGroup & Chr(39), ',', 'Benchmark');

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 19:11:11 GMT

I think you are on to something. I tried the following expression in a text box with the alternate state Benchmark. I was able to get it to work as the following in a textbox. However, it's still not working in the set analysis expression

=GetFieldSelections( ProcGroup , , , Benchmark)

Re: Alternate State Variable in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 19:13:12 GMT

You didn't add the single quotes using Chr(39). Is that for a reason?

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 19:16:38 GMT

It wouldn't work with the single quotes, or double quotes chr(34). Unless I had them incorrectly entered.

LET eProcedureGroup = 'GetFieldSelections(&Chr(39)&ProcGroup&Chr(39)& , , , Benchmark)' ;

Re: Alternate State Variable in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 19:21:26 GMT

Try removing these

LET eProcedureGroup = 'GetFieldSelections(&Chr(39)&ProcGroup&Chr(39)& , , , Benchmark)';

To this:

LET eProcedureGroup = 'GetFieldSelections(Chr(39)&ProcGroup&Chr(39) , , , Benchmark)';

Re: Alternate State Variable in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 19:22:57 GMT

Also try the above with set to see if that give you anything when you use the variable.

Re: Alternate State Variable in Set Analysis

swuehl — Tue, 20 Sep 2016 19:25:32 GMT

I don't think GetFieldSelections() works with a calculated field as argument, try

LET eProcedureGroup = chr(39) & GetFieldSelections( ProcGroup ,''',''' , , Benchmark) & chr(39);

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 19:40:18 GMT

LET eProcedureGroup = 'GetFieldSelections(Chr(39)&ProcGroup&Chr(39) , , , Benchmark)';;

SET eProcedureGroup1 = 'GetFieldSelections(Chr(39)&ProcGroup&Chr(39) , , , Benchmark)';;

Top two text boxes are eProcedureGroup , second is eProcedureGroup1 :

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 20:24:32 GMT

Stefan, your response is the bottom two, with the syntax.

Re: Alternate State Variable in Set Analysis

swuehl — Tue, 20 Sep 2016 20:38:04 GMT

I think you also need to quote the alternate state and maybe add an argument for the third argument.

And replace LET with SET:

This worked at my site:

SET eProcedureGroup = =chr(39) & GetFieldSelections( ProcGroup,chr(39)&','&chr(39),100,'Benchmark' ) & chr(39);

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 20:58:17 GMT

I can get the text boxes to populate without an issue. But, what I'm trying to accomplish with my set analysis shown below in the image doesn't work.

Also, adding the following variables don't display in the textbox when calling the variable, I also tried LET:

SET eProcedureGroup = "=chr(39) & GetFieldSelections( ProcGroup,chr(39)&','&chr(39),100,'Benchmark' ) & chr(39)";

SET eProcedureGroup1 = =chr(39) & GetFieldSelections( ProcGroup,chr(39)&','&chr(39),100,'Benchmark' ) & chr(39);

Re: Alternate State Variable in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 21:00:27 GMT

Remove the double quotes around your variable in the modifier

{Benchmark<ProcGroup= {$(eProcedureGroup)}>}

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 21:12:28 GMT

Much easier than we made it out to be... Thanks Sunny and Stefan.

Re: Alternate State Variable in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 21:14:11 GMT

qvelhoff‌ - I think Stefan deserve the correct answer more than me, because he is the one you got you on the right track. I think it would be better of if you mark his response as correct as most people will have more trouble sorting out the variable in script sorted out rather than getting the set analysis fixed.

Thanks and regards

Sunny

Re: Alternate State Variable in Set Analysis

swuehl — Tue, 20 Sep 2016 21:17:35 GMT

I'm fine with that.

But could you please summarize which exact definitions you ended up with? I think that would be most helpful.

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 21:20:59 GMT

My variable is defined as: SET vProcedureGroup ="GetFieldSelections( ProcGroup , , , Benchmark)".

The trouble was the double quotes around the variable.

Re: Alternate State Variable in Set Analysis

sunny_talwar — Tue, 20 Sep 2016 21:23:21 GMT

Hahahahaha okay

Re: Alternate State Variable in Set Analysis

swuehl — Tue, 20 Sep 2016 21:29:33 GMT

Ok, thanks, Nick. Does your variable work also when selecting multiple values?

Re: Alternate State Variable in Set Analysis

NickHoff — Tue, 20 Sep 2016 21:31:44 GMT

I don't believe it would, but for my use case ProcGroup is set as always one selected. I'd have to use concat with your expression for it to work.