Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in variable

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

3 Replies
sunny_talwar

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.

Not applicable
Author

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')

sunny_talwar

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?