topic Re: If condition issue in QlikView

If condition issue

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: If condition issue

ValeriyaBartosh — Mon, 27 Aug 2018 13:40:12 GMT

hello, could you please add qvw?

Re: If condition issue

Anil_Babu_Samineni — Mon, 27 Aug 2018 13:43:23 GMT

Remove NOT APPLICABLE and Test?

Re: If condition issue

sangeess21 — Mon, 27 Aug 2018 20:24:41 GMT

Try removing ,'NOT APPLICABLE'

Re: If condition issue

ValeriyaBartosh — Tue, 28 Aug 2018 06:07:13 GMT

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