Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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?

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
Partner

hello, could you please add qvw?

Anil_Babu_Samineni

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

Try removing ,'NOT APPLICABLE'

ValeriyaBartosh
Partner
Partner

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