topic How do I set the value of a variable based on the value of another variable in an IF THEN statement? in QlikView

How do I set the value of a variable based on the value of another variable in an IF THEN statement?

Thu, 05 Jun 2014 22:55:34 GMT

I was trying to do a simple series of set variable statements based on the value of another variable, like this:

IF $(vCurrentYear) = "2013-14" THEN

SET vPrevYear = "2012-13";

IF $(vCurrentYear) = "2014-15" THEN

SET vPrevYear = "2013-14";

But these cause the script to load nothing at all, and an hour of Googling hasn't gotten me anywhere. This seems like it should be a very simple thing. Is there a better way to do this? Thanks in advance!

Re: How do I set the value of a variable based on the value of another variable in an IF THEN statement?

Fri, 06 Jun 2014 00:31:47 GMT

make it

if '$(vCurrentYear)'='2013-14' then

set......

if '$(vCurrentYear)'='2014-15'

Your variable stores a string so the Dollar sign expansion needs to be enclosed within single quotes.

Re: How do I set the value of a variable based on the value of another variable in an IF THEN statement?

jagan — Fri, 06 Jun 2014 01:51:01 GMT

Hi Shawn,

Try like this

SET vCurrentYear = '2013-14';

IF vCurrentYear = '2013-14' THEN

SET vPrevYear = '2012-13';

ELSEIF vCurrentYear = '2014-15' THEN

SET vPrevYear = '2013-14';

END IF;

Regards,

Jagan.

Re: How do I set the value of a variable based on the value of another variable in an IF THEN statement?

fkeuroglian — Fri, 06 Jun 2014 02:24:14 GMT

Hi, try this

set vCurrentYear ='2013-14';

IF '$(vCurrentYear)' = '2013-14' THEN

SET vPrevYear = '2012-13';

IF $(vCurrentYear) = '2014-15' THEN

SET vPrevYear = '2013-14';

END if

end if

good luck!

Fernando

Re: How do I set the value of a variable based on the value of another variable in an IF THEN statement?

Fri, 06 Jun 2014 15:52:08 GMT

Worked perfectly.

Thanks so much, Jagan!