topic Re: What the $(expansion) am I doing wrong in QlikView

What the $(expansion) am I doing wrong

dgreenberg — Wed, 23 Mar 2016 17:57:34 GMT

let vEngNumber=peek('ePartner',$(vRand),'Sampling1');

This works and returns a value like Greenberg, Dan

Where I am having trouble is

Sampling2:

Load

eEngNumber,

ePartner,

[Engagement Start Date]

Resident Sampling1

where ePartner <> $(vPartnerB);

I need to wrap the $(vPartnerB) with single quotes otherwise it's interpreted as

where ePartner <>Greenberg,Dan

what I want is

where ePartner <> 'Greenberg,Dan'

What am I doing wrong?

Re: What the $(expansion) am I doing wrong

Anonymous — Wed, 23 Mar 2016 18:02:41 GMT

Maybe put the single quotes round it :

.... where ePartner <> '$(vPartnerB)';

Re: What the $(expansion) am I doing wrong

swuehl — Wed, 23 Mar 2016 18:06:18 GMT

Dan Greeberg wrote:

let vEngNumber=peek('ePartner',$(vRand),'Sampling1');

I need to wrap the $(vPartnerB) with single quotes otherwise it's interpreted as

where ePartner <>Greenberg,Dan

what I want is

where ePartner <> 'Greenberg,Dan'

What am I doing wrong?

Not sure if I understand your question, I think you've already answered it, wrap the dollar sign expansion in single quotes.

So this is not working for you?

Re: What the $(expansion) am I doing wrong

sunny_talwar — Wed, 23 Mar 2016 18:26:22 GMT

I think this should also work:

LET vEngNumber=Chr(39) & Peek('ePartner',$(vRand),'Sampling1') & Chr(39);

and then this:

Sampling2:

Load

eEngNumber,

ePartner,

[Engagement Start Date]

Resident Sampling1

where ePartner <> $(vPartnerB);

Re: What the $(expansion) am I doing wrong

dgreenberg — Wed, 23 Mar 2016 18:29:12 GMT

Thank you Sunny.

This worked

Re: What the $(expansion) am I doing wrong

sunny_talwar — Wed, 23 Mar 2016 18:30:02 GMT

I would have assumed Bill's method to have worked as well. That did not work?

Re: What the $(expansion) am I doing wrong

dgreenberg — Wed, 23 Mar 2016 18:33:36 GMT

'$(vPartnerB)' is interpreted as '''Greenberg, Dan''' and did not work.

Re: What the $(expansion) am I doing wrong

swuehl — Wed, 23 Mar 2016 19:00:51 GMT

Dan Greeberg wrote:

'$(vPartnerB)' is interpreted as '''Greenberg, Dan''' and did not work.

That's how the document log or debug screen logs the expanded variable? With added double quotes?

Interesting, that's against everything I've learned about how dollar sign expansion should work...

Re: What the $(expansion) am I doing wrong

dgreenberg — Wed, 23 Mar 2016 19:03:42 GMT

Wrapping the dollar sign expansion in single quotes does not work in my where clause but ch(39) & $(vPartnerB) & chr(39) works

Re: What the $(expansion) am I doing wrong

swuehl — Wed, 23 Mar 2016 19:20:33 GMT

Are you sure you've tried adding the single quotes at the right place?

LET vEngNumber=Chr(39) & Peek('ePartner',$(vRand),'Sampling1') & Chr(39);

and then this:

Sampling2:

Load

eEngNumber,

ePartner,

[Engagement Start Date]

Resident Sampling1

where ePartner <> $(vPartnerB);

Sunny's change should have had no effect at all, since variable vEngNumber is not used in the where clause.

edit: And don't take me wrong, Dan, I just want to understand why the trivial solution doesn't work...

Re: What the $(expansion) am I doing wrong

sunny_talwar — Wed, 23 Mar 2016 19:24:01 GMT

vEngNumber is infact vPartnerB is my guess.

I might be totally wrong

Re: What the $(expansion) am I doing wrong

harsh44_bhatia — Mon, 18 Jul 2016 18:01:58 GMT

Hello Swuehl,

Even i would like to clear this point. I was too struggling with the same issue.

if(match([Report Name], '$(vReportList)' ), 1 ,0) as Flag

vReportList though given in single quotes with DSE was not working. The solution provided by Sunny worked for me.

I did see the logs where the '$()' was converting the string to: 'hjbjhb'',''cvsdc'',''xcd'',''csasdc'

So each single quote withing the string was converted to double quote, posibily that was the reason match function did not work. But again i am confused why would this happen.

Harshit