topic Re: Need weeday query in QlikView

Need weeday query

Wed, 20 May 2015 11:58:49 GMT

if day Thursday is there of every month then don't show data.

if day Friday is there of every month then show Friday & Thursday data combine.

that means it should show Friday & Thursday data in one single line .

Please find the excel in for your reference.

Re: Need weeday query

jpenuliar — Wed, 20 May 2015 14:11:15 GMT

= num(Weekday(Date(today()))) results 2

You can use this to derive the numeric equivalent of Days:

Wednesday = 2,Thursday = 3, Friday = 4 ...

you can use this logic to add field in your calendar to flag the days (thu and fri) or use in your charts

Re: Need weeday query

Thu, 21 May 2015 06:55:44 GMT

Can you please send me the syntax of this issue.

I am using this query as :

if(WeekDay([DATE])='Thursday','0',date(DATE)) as New_Date,

if(WeekDay([DATE])='Friday','Thursday + Friday',date(DATE)) as New_Date1,

But this does not give proper output.

If Possible Please send me syntax of it as soon as possible.

Re: Need weeday query

jpenuliar — Thu, 21 May 2015 08:55:57 GMT

try the below:

=If(num(Weekday(Date('22/05/2015'))) = 3,'Thu',If(num(Weekday(Date('22/05/2015'))) = 4,'Fri',''))

Re: Need weeday query

Thu, 21 May 2015 10:00:14 GMT

Dear Sir,

Thanks for your reply.

Syntax which is send does not give combine data of Friday & Thursday

Please see the attached Excel sheet for date format of report its the actual requirement.

For eg : In Month of May from 1st to 6th May it will show data From 1st to 6th ; 7th May is Thursday is does not display that date in the excel and display the data ; directly it show Friday & Thursday data i.e 7th & 8th May it will show both the date data in one single line.

I hope you have got my issue.

Please send the syntax of it as soon as possible.

Regards

Re: Need weeday query

jpenuliar — Thu, 21 May 2015 10:09:23 GMT

Then do :

=If(num(Weekday(Date('22/05/2015'))) = 3,'Thu and Fri',If(num(Weekday(Date('22/05/2015'))) = 4,'Thu and Fri',''))

Re: Need weeday query

Fri, 22 May 2015 07:40:14 GMT

Dear Jon,

Still it does not give correct output.

Please refer the attached excel sheet for format.

Regards

Re: Need weeday query

jpenuliar — Fri, 22 May 2015 12:30:24 GMT

Hi gaikar.surekha,

can you post your qv app

Re: Need weeday query

MarcoWedel — Fri, 22 May 2015 22:53:48 GMT

Hi,

one possible solution could be to use a calculated dimension like this instead of the date dimension:

=If((WeekDay(Date)=3 or WeekDay(Date)=4) and (Month(Date+(WeekDay(Date)=4))=Month(Date+(WeekDay(Date)=4)+1)),Dual(Num(Day(Date+(WeekDay(Date)=4)),'00')&'&'&Date(Date+(WeekDay(Date)=4)+1),Date+(WeekDay(Date)=4)),Date(Date))

hope this helps

regards

Marco