Item per day in set analysis

[#1]

I have a data set with Requestors (employees) making orders with an associated creation date. I am looking to put together an expression where it counts the number of unique requestors who ONLY have submitted an order once a week and once a month.

# unique requestors = Count(DISTINCT [Requested By])

Orders = [Order ID]

Date = [Creation Date]

[Gysbert_Wassenaar]

Please post a small qlikview document that demonstrates the problem.

[#3]

Best I can do, data might not be the best but just looking for the right expression.

[Kushal_Chawda]

There is no Requested By associated with Creation Date in your sample

[#5]

[Gysbert_Wassenaar]

As Kush141087‌ says the creation dates ofthe orders and the calendar don't match up:

That's because the creation dates you load from the excel file are timestamps with a time part too. Make a date and a time field out of it:

Test:

LOAD [Order ID],

     Date(Floor([Requested Created]) as [Creation Date],

     Time(Frac([Requested Created]) as [Creation Time],

     [Requested By],

     [Item Price],

     [Item Quantity],

     [Item Total]

FROM

[..\Data\2015_Epurchase and IS Inovices.xlsx]

(ooxml, embedded labels, table is Test);

[#7]

ahh gotcha! what about this one?

[Gysbert_Wassenaar]

Ok, that looks better. Now, can you tell me what you're asking. It's not quite clear to me.

I am looking to put together an expression where it counts the number of unique requestors who ONLY have submitted an order once a week and once a month.

Does that mean the requestors that submitted at least one order each week and each month? Or the requestors that submitted at the most one request per week and per month? Or even something else?

In your data there are no requestors that made more than one request per week or per month.

[#9]

Since this is blinded data, there probably won't be any concrete examples from the expression.

I am looking to identify requestors that submitted at the most one request per week and the ones that requested at the most one per month? Sorry for the confusion.

[Gysbert_Wassenaar]

Ok, at the most one request for each week, i.e. 6 requests in 6 weeks, or just never more then one request for any week, i.e. 0 or 1 requests for each week.