topic Re: count between dates in QlikView

count between dates

ilanbaruch — Mon, 21 Dec 2015 08:33:49 GMT

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

Re: count between dates

ajsjoshua — Mon, 21 Dec 2015 08:37:12 GMT

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)

Re: count between dates

alexandros17 — Mon, 21 Dec 2015 08:37:33 GMT

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

Re: count between dates

tresB — Mon, 21 Dec 2015 08:39:16 GMT

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')