Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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..




Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: If condition issue

Remove NOT APPLICABLE and Test?

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
Highlighted
Partner
Partner

Re: If condition issue

hello, could you please add qvw?

Highlighted

Re: If condition issue

Remove NOT APPLICABLE and Test?

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

Highlighted
Creator
Creator

Re: If condition issue

Try removing ,'NOT APPLICABLE'

Highlighted
Partner
Partner

Re: If condition issue

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