Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to do a count of customers based on a particular date:
= count({<
Period_Date={"$(='31/01/2011')"}
>} CUSTOMER_ID)
The set analysis above doesn't work - I just get 0, could anyone give me some pointers please? Any help would be much appreciated
I only changed that and go it to work, see attached
COUNT({<Period_Date = {'31/01/2011'}>}CUSTOMER_ID)
or
COUNT({<Period_Date = {'31/01/2011'}>}DISTINCT CUSTOMER_ID)
try
count({<Period_Date={'31/01/2011'}>} CUSTOMER_ID)
pay attention to date format that is period_date format must br DD/MM/YYYY
Hi Manish and Alessandro
Thank you both for your suggestions, but that isn't working either for some reason (still getting 0 and I know I should be getting approx 140k...) - and I have checked that I'm using the correct date format.
could you send a sample doc
Hi Siobhan,
Is there potentially some other selections that are affecting you result? Try
count({1< Period_Date={'31/01/2011'}>} CUSTOMER_ID)
This will ignore all selections and just select that period date only
hope that helps
Joe
I am sure the syntax is correct so try without set analysis
count(CUSTOMER_ID)
if it works (as I suppose try with
count({$ <Period_Date={'>01/01/2011'}>} CUSTOMER_ID)
or
count({$ <Period_Date={'>2011/01/01'}>} CUSTOMER_ID)
let me know
Hi Carly
I couldn't send the original app as it has some sensitive stuff in it, but here's a mock up - thanks for your help. Unfortunately I only have the free version of QV available to me at the moment so I can't open other people's files...
It was how you spelt customer id, it looked right as the spelling was correct but the capitals cause it to error although it doesn't tell you, try this:
count({<Period_Date ={'31/01/2011'}>} Customer_ID)
Hi Carly - it's not that, the spelling in the main app is CUSTOMER_ID, I just didn't write copy it properly in the mock up (sorry for the confusion)