topic Re: Issue in variable in QlikView

Issue in variable

Mon, 27 Jul 2015 18:33:09 GMT

Hi swuehl maxgro sunindia RamonCova06 RebeccaD,

Every Sunday and Monday my variable returns a Fail result. I don't know why. Practically it should be pass. Can some one have a look at it.

Thanks in advance.

Regards,

Sachin

Re: Issue in variable

sunny_talwar — Mon, 27 Jul 2015 18:44:04 GMT

You right hand side of the if statement seems to work (gives Pass) only if you are checking for Today() - 2, anything after that will always give you Faill, unless the [Update Date Num] also updates. Right now with just Today() you get 42211 and [Update Date Num] = 42209 which is less than your right hand side and will result in a failure.

Re: Issue in variable

Mon, 27 Jul 2015 19:00:51 GMT

Hi Sunny,

So my expression should be like this:

IF( [Update Date Num] >=NUM(yearstart(Today())) - 3
+ (IF( Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today()))),1)= 'X' OR Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today()))),1) = 'H',
IF( Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-1 ,1)= 'X' OR Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-1 ,1) = 'H',
IF( Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-2 ,1)= 'X' OR Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-2 ,1) = 'H',
IF( Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-3 ,1)= 'X' OR Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-3 ,1) = 'H',
IF( Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-4 ,1)= 'X' OR Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-4 ,1) = 'H',
IF( Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-5 ,1)= 'X' OR Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-5 ,1) = 'H',
IF( Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-6 ,1)= 'X' OR Mid([Calendar String],61 + (NUM(Today()) - yearstart(NUM(Today())))-6 ,1) = 'H',
(NUM(Today()) - yearstart(NUM(Today())))-7
, (NUM(Today()) - yearstart(NUM(Today())))-6 )
, (NUM(Today()) - yearstart(NUM(Today())))-5 )
, (NUM(Today()) - yearstart(NUM(Today())))-4 )
, (NUM(Today()) - yearstart(NUM(Today())))-3 )
, (NUM(Today()) - yearstart(NUM(Today())))-2 )
, (NUM(Today()) - yearstart(NUM(Today())))-1 )
,(NUM(Today()) - yearstart(NUM(Today()))) ) ), 'Pass', 'Fail')

Re: Issue in variable

sunny_talwar — Mon, 27 Jul 2015 19:03:44 GMT

I don't know. What are you trying to do here??? I don't understand the whole expression, I will have to dig deep into it to understand what you are trying to do. Can you explain what are you trying to do here?