Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
nareshthavidishetty
Contributor 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

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

Re: If condition issue

hello, could you please add qvw?

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

sangeess21
Contributor

Re: If condition issue

Try removing ,'NOT APPLICABLE'

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