topic Re: Qlikview variable expression in Load Script in QlikView

Qlikview variable expression in Load Script

wallerjc — Thu, 11 Jun 2015 15:12:52 GMT

I have a load script and I'm trying to do the following variable:

set vTest = if('$(dialMode)'='Month',sum(Comps.SpendDollers));

When I run this script and look in my "Variable Overview" I can see that it's coming out to:

if('Week'='Month',sum(Comps.SpendDollers))

Could someone explain to me how I get the variable "dialMode" to evaluate when I use the variable in my document, and not when the Load Script is ran?

I hope I've made myself clear, please let me know if not.

Re: Qlikview variable expression in Load Script

maxgro — Thu, 11 Jun 2015 15:26:32 GMT

maybe

let vTest2 = 'if(' & chr(39) & chr(36) & '(dialMode)' & chr(39) & '=' & chr(39) & 'Month' & chr(39) & ',sum(Comps.SpendDollers))';

Re: Qlikview variable expression in Load Script

wallerjc — Thu, 11 Jun 2015 15:45:17 GMT

Are you a f***ing wizard?! That's the most disgusting expression I've seen and it works perfectly.

Is this documented anywhere?

Re: Qlikview variable expression in Load Script

wallerjc — Thu, 11 Jun 2015 15:50:17 GMT

nevermind actually i've worked out why this is working thanks.

Re: Qlikview variable expression in Load Script

maxgro — Thu, 11 Jun 2015 15:53:54 GMT

sometimes it's used in set analysis

Re: Dollar sign expansion and Set Analysis?