Set Analysis

[#1]

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

[#2]

Hi Byron,

Please, attach an example of the QV application.

Kind regards,

Janusz

[IAMDV · Accepted solution]

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.

[#4]

Thanks, formatting was the issue

[#5]

Hi Byron,

Check the attached application. this works for me. As "DV" said you may need to check your DateTime formate for Week.

- Sridhar