Need weeday query

[#1]

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.

[jpenuliar]

= 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

[#3]

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.

[jpenuliar]

try the below:

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

[#5]

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

[jpenuliar]

Then do :

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

[#7]

Dear Jon,

Still it does not give correct output.

Please refer the attached excel sheet for format.

Regards

[jpenuliar]

Hi gaikar.surekha,

can you post your qv app

[MarcoWedel]

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