topic Multiple IF Statement in QlikView

Multiple IF Statement

qliklearnervir — Fri, 14 Aug 2015 10:33:27 GMT

Hi,

In my scenerio i want to fatch the next extract date according to my selection and values .

in below code $(vDate ) is date selection from calendar.......

issue is in my code if calendar date is today but my code will give the future next date instead of today date.

i want a mechanism that if i select today's date in $(vDate) than it should show today's date ...else future date as per below code.......

if(RowNo()=1,date(Weekstart($(vDate),1),'DD-MMM-YY'),

if(RowNo()=2,date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

if(RowNo()=3,date(weekstart($(vDate),1),'DD-MMM-YY'),

if(RowNo()=4,date(weekstart($(vDate),1,1),'DD-MMM-YY'),

if(RowNo()=5,date(weekstart($(vDate),1,2),'DD-MMM-YY'),

if(RowNo()=6,date(weekstart($(vDate),1,3),'DD-MMM-YY'),

if(RowNo()=7,date(weekstart($(vDate),1,2),'DD-MMM-YY'),

if(RowNo()=8,date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

if(RowNo()=9,date(Weekstart($(vDate),0,-3),'DD-MMM-YY'))))))))))

Re: Multiple IF Statement

Gysbert_Wassenaar — Fri, 14 Aug 2015 10:46:02 GMT

Something like this maybe:

If(num(today())=num($(vDate)),today(),

pick(match(RowNo(),1,2,3,4,5,6,7,8,9),

date(Weekstart($(vDate),1),'DD-MMM-YY'),

date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

date(weekstart($(vDate),1),'DD-MMM-YY'),

date(weekstart($(vDate),1,1),'DD-MMM-YY'),

date(weekstart($(vDate),1,2),'DD-MMM-YY'),

date(weekstart($(vDate),1,3),'DD-MMM-YY'),

date(weekstart($(vDate),1,2),'DD-MMM-YY'),

date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

date(Weekstart($(vDate),0,-3),'DD-MMM-YY')))

Re: Multiple IF Statement

qliklearnervir — Fri, 14 Aug 2015 11:59:15 GMT

I have to clear my requirement.....there are column called Next Extract Date....As per Code it's showing future date ....but if for example for week 26 column i am selecting date 17th august ...it will show me the value 24th august ......but i want if i am selecting today's date it should show Next Extract date as today's date else future date .........same for all the values kindly suggest,.

if(RowNo()=1,date(Weekstart($(vDate),1),'DD-MMM-YY'),

if(RowNo()=2,date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

if(RowNo()=3,date(weekstart($(vDate),1),'DD-MMM-YY'),

if(RowNo()=4,date(weekstart($(vDate),1,1),'DD-MMM-YY'),

if(RowNo()=5,date(weekstart($(vDate),1,2),'DD-MMM-YY'),

if(RowNo()=6,date(weekstart($(vDate),1,3),'DD-MMM-YY'),

if(RowNo()=7,date(weekstart($(vDate),1,2),'DD-MMM-YY'),

if(RowNo()=8,date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

if(RowNo()=9,date(Weekstart($(vDate),0,-3),'DD-MMM-YY'))))))))))

Screenshot given below for req....

Re: Multiple IF Statement

Peter_Cammaert — Fri, 14 Aug 2015 12:31:44 GMT

You mean that if field "Extract Day" which probably represents some data in your document equals the weekday of today() (e.g. Friday), then "Next Extract Date" should be set to the value of today()? Then how about this minor modification of Gysbert's code?

If([extract Day]=date(today(), 'WWWW'),today(),

pick(match(RowNo(),1,2,3,4,5,6,7,8,9),

date(Weekstart($(vDate),1),'DD-MMM-YY'),

date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

date(weekstart($(vDate),1),'DD-MMM-YY'),

date(weekstart($(vDate),1,1),'DD-MMM-YY'),

date(weekstart($(vDate),1,2),'DD-MMM-YY'),

date(weekstart($(vDate),1,3),'DD-MMM-YY'),

date(weekstart($(vDate),1,2),'DD-MMM-YY'),

date(Weekstart($(vDate),0,-3),'DD-MMM-YY'),

date(Weekstart($(vDate),0,-3),'DD-MMM-YY')))

Peter

Re: Multiple IF Statement

qliklearnervir — Fri, 14 Aug 2015 12:52:22 GMT

there are some more refine output i want .....

As given in the above image .......i have a calendar and $(vDate) is the value of the calendar......

Extract day is set by business ......now i want that for example :-

(1) for extract day "Monday" I will select in Calendar "17th Aug2015" than my Next Extract date should be 17th only ......but in current scenerio it will show me the next week 24th august 2015.......

as per requirement first the day when the extract should happen ....to complete after that the next extract date should show future date.......

(2) as per scenerio our 17th august 2015 is selected ...so the my table should show next extract date 17th 2015 .....if i will select 18th august in calendar than .....next extract date should be 24th august 2015....

I think my requirement is clear for every one........