topic Re: Week Day in Expression in QlikView

Week Day in Expression

Fri, 19 Feb 2016 13:33:19 GMT

Hello all ,

Kindly help me on the below scenario ,

If its Monday , I have to display the sum of previous three days sold amount(Friday,Saturday and Sunday) , otherwise it should show only the Previous day Sold amount. I tired the below expression . But I couldn't succeed.

if(WeekDay([Sales Date])=0,

(Sum(if([Sales Date]=Today()-3 or [Sales Date]=Today()-2 or [Sales Date]=Today()-1,[Sold Amount]))),

(Sum(if([Sales Date]=Today()-1,[Sold Amount]))))

Format in the Script: SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Thank you in Advance.

Best Regards,

Siva

Re: Week Day in Expression

sunny_talwar — Fri, 19 Feb 2016 14:20:28 GMT

Do you mean Max([Sales Date]) = Monday? or Today is Monday? Are you doing any selections on the date field? Would you be able to share a sample with expected output?

Re: Week Day in Expression

Peter_Cammaert — Fri, 19 Feb 2016 15:59:44 GMT

Change the first part into:

if(WeekDay(Today())=0, ...

Your expression will not do what you expect, as a simple reference to [Sales Date] outside of any aggregation function may return a lot of Sales Dates.

Peter