Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
= 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
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.
try the below:
=If(num(Weekday(Date('22/05/2015'))) = 3,'Thu',If(num(Weekday(Date('22/05/2015'))) = 4,'Fri',''))
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
Then do :
=If(num(Weekday(Date('22/05/2015'))) = 3,'Thu and Fri',If(num(Weekday(Date('22/05/2015'))) = 4,'Thu and Fri',''))
Dear Jon,
Still it does not give correct output.
Please refer the attached excel sheet for format.
Regards
Hi gaikar.surekha,
can you post your qv app
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