Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

If condition issue

Hi,

I have used the below if condtion.

     if(num([Calendar Date]) - num([Start Date])<=30, '0 TO 30 DAYS',

if(num([Calendar Date]) - num([Start Date])<=60, '31 TO 60 DAYS',

if(num([Calendar Date]) - num([Start Date])<=75, '61 TO 75 DAYS',

if(num([Calendar Date]) - num([Start Date])<=90, '76 TO 90 DAYS',

  if(num([Calendar Date]) - num([Start Date])<=180, '91 TO 180 DAYS',

         if(num([Calendar Date]) - num([Start Date])<=365, '181 TO 365 DAYS',

          if(num([Calendar Date]) - num([Start Date])> 365,'>365 DAYS','UNKNOWN'))))))),'NOT APPLICABLE'

But i'm getting only NOT APPLICABLE.


Please let me know the right one.


Thanks..




1 Solution

Accepted Solutions
Anil_Babu_Samineni

Remove NOT APPLICABLE and Test?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
ValeriyaBartosh
Partner - Contributor III
Partner - Contributor III

hello, could you please add qvw?

Anil_Babu_Samineni

Remove NOT APPLICABLE and Test?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sangeess21
Creator
Creator

Try removing ,'NOT APPLICABLE'

ValeriyaBartosh
Partner - Contributor III
Partner - Contributor III

I think , there are some situations when [Calendar Date] or [Start Date] is null, and in this situation if condition gives NOT APPLICABLE  like/as  ELSE