topic Re: Issue with $ expansion when space in text input in QlikView

Issue with $ expansion when space in text input

Sat, 21 Jul 2012 02:12:56 GMT

Hi,

I am having an issue with $ expansion where the text has space (Brand name has space) and is not working. Below is the expression that works when the text in the Brand is single word. But doesn't when it has 2 or more words with a space.

sum

(

{1<

Brand={$(=Brand)}

sales

)

I tried putting the quotes as below (this was suggested in one of the posts but it didn't work)

sum

(

{1<

Brand={'$(=Brand)'}

sales

)

I will try any of your suggestions to resolve this seemingly simple issue.

Thanks,

Deepak

Re: Issue with $ expansion when space in text input

Jason_Michaelides — Sat, 21 Jul 2012 12:38:41 GMT

Your second attempt is almost right! Use double-quotes instead of single...:

sum({1<Brand={"$(=vBrand)"}>} sales) where vBrand is your variable for brand input.

Hope this helps,

Jason

Re: Issue with $ expansion when space in text input

swuehl — Sat, 21 Jul 2012 15:59:31 GMT

Interesting,

I would have assumed that Deepak's second expression

sum({1<Brand={'$(=vBrand)'}>} sales)

should work as is

(I personally would have written something like sum({1<Brand={'$(vBrand)'}>} sales)

i.e no equal sign (no dollar sign expansion with an Expression, just a plain variable call) ).

At my site, all 3 expressions do work (in Jason's sample app).

Regards,

Stefan

Re: Issue with $ expansion when space in text input

Jason_Michaelides — Sat, 21 Jul 2012 17:28:06 GMT

Do you know - I swear I tried both Deepak's expression before and it didn't work. I guess I musn't have though, as all 3 work for me too (that's Deepak's 2nd exp, my exp and Stefan's).

I guess Stefan's straight variable call would be the most efficient.

Jason

Re: Issue with $ expansion when space in text input

Mon, 23 Jul 2012 03:12:57 GMT

Thank you very much. The double quotes did it. - Deepak