Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

count between dates


hi all,

I want to count number of transactions from registration date and one week further, for example:(DD/MM/YYYY)

client register in 01/01/2015, I want to count how many trans. he made until 07/01/2015.

thank you

Ilan

3 Replies
ajsjoshua
Specialist
Specialist

Hi,

Pls go through.

Consider that you have selected 03/12/2105

If you want 01/01/2015 to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}Sales)

If you want min Date to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=Min({1}Date))<=$(=Max(Date))"}>}Sales)

alexandros17
Partner - Champion III
Partner - Champion III

You can transform a date into a numerical representation with the function Num(myDate), just add to your result the value 7, then simply count your transactions where transaction date is >= Num(DateStart) and <= Num(DateStart)+7

let me know

tresesco
MVP
MVP

Try like:

Count({<MsaterCalDate={">=$(=Only(TransactionDate))<=$(=Date(Only(TransactionDate)+6, 'DD/MM/YYYY'))"}>}transaction)

Assuming your MasterCalDate would be of similar date format ( 'DD/MM/YYYY')