Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I'm messing around with the different identifies, modifers and operators to see what they actually do 🙂
I written this code in my one expression sum({1<CostCode={'Normal Time'}, Week={'2011/02/28'}>}Hours)
And in my pie chart I get no data to display. This 'code' works fine without the week part in there. Could it not be populating because I have either not deifined the date correctly or what 🙂
Oh and the context around what I am trying to do with this set analysy. I want to see only weekly hours where the cost code is Normal Time and for a particular week. It needs to be independent of any selections in my worksheet
Thanks,
Byron
Byron - Your date should be same as Week field. Also try using the [ ] brackets around the date or use the DATE and TIME functions for explicit date format conversions.
You can post the QV document with sample data and I am sure one of us from the forum will help you.
Hi Byron,
Please, attach an example of the QV application.
Kind regards,
Janusz
Byron - Your date should be same as Week field. Also try using the [ ] brackets around the date or use the DATE and TIME functions for explicit date format conversions.
You can post the QV document with sample data and I am sure one of us from the forum will help you.
Thanks, formatting was the issue
Hi Byron,
Check the attached application. this works for me. As "DV" said you may need to check your DateTime formate for Week.
- Sridhar