topic Re: Weekday issue help!! in QlikView

Weekday issue help!!

Thu, 25 Jun 2015 06:46:12 GMT

Hi All

what i expect is - when i select sunday's of the month=6 as per weekday , it should show data from <fri - sunday>,else normal.

what i am getting is - for the first sunday i m getting wrong data , rest 3 sunday's its fine.....

Please find below the logic I am using in my expression to get the output.

=if(Weekday(vCalendar)<>6

,sum({<[Sales Stage Date]= {"$(=Date(vCalendar,'DD/MM/YYYY'))"},[Involvement] = {'with Services', ' not with Services'}>}[Amount])

,sum({<[Sales Stage Date]= {">=$(=Date(vCalendar-2,'DD/MM/YYYY'))"}*{"<=$(=Date(vCalendar,'DD/MM/YYYY'))"}

,[Involvement] = {'with Services', ' not with Services'}>}[Amount]))

Please suggest

Thanks in Advance

Timba

Re: Weekday issue help!!

jonathandienst — Thu, 25 Jun 2015 06:50:28 GMT

The is the correct syntax for the second part of your expression:

sum({<[Sales Stage Date]= {">=$(=Date(vCalendar-2,'DD/MM/YYYY')) <=$(=Date(vCalendar,'DD/MM/YYYY'))"}, Involvement = {'with Services', ' not with Services'}>} Amount)

Re: Weekday issue help!!

Thu, 25 Jun 2015 07:00:45 GMT

Hi Jona

Issue is still the same even after using the above querry in expression,its showing data for first sunday of every month.............where as i want no data on sundays

Thanks

Timba