topic Re: LIKE $(dollar-sign variable) Help in QlikView

LIKE $(dollar-sign variable) Help

Thu, 29 May 2014 09:29:20 GMT

Hi,

It's a quick and simple one today:

Sum(IF(Comp_Competitor like $(CompetitorName) & '*', Comp_MediaSpend))

How can I write this so qlikview will understand?

Example variable value is "Tesco"

Example working expression is:

Sum(IF(Comp_Competitor like 'Tesco*', Comp_MediaSpend))

Could someone help me convert the above working expression to replace 'Tesco*' with a variable I've specified in the load script?

Many thanks,

James.

tresB — Thu, 29 May 2014 09:32:42 GMT

=Sum(IF(WildMatch(Comp_Competitor, $(CompetitorName) & '*'), Comp_MediaSpend))

Thu, 29 May 2014 09:34:19 GMT

Sum(IF(Wildmatch(Comp_Competitor,'Tesco*'),Comp_MediaSpend)

something like the above should work

Edit damn u tresco u too fast this early in the morning!!!

tresB — Thu, 29 May 2014 09:40:56 GMT

And, if you don't include single qoutes in variable declaration, you might have to do it here like:

=Sum(IF(WildMatch(Comp_Competitor, '$(CompetitorName)' & '*'), Comp_MediaSpend))

Note the quates around variable expansion.

Thu, 29 May 2014 09:41:27 GMT

Marked as helpful simply for the speed

Cheers bud,

James.

Thu, 29 May 2014 10:07:17 GMT

Hi jwaller,

example for you with if and with set analysis.

regards

Darek