Specific dates

[Anonymous]

I am working with accounts receivables data and would like to show an accounts receivables statement per a specific date in QlikSense.

How can I enter a field where I can choose to display the accounts receivable statement as per for example 2016-07-31 and not just per today?

Thank you!

[Gysbert_Wassenaar]

That depends on your data model. Without information I can only say "make the appropriate selection", but I doubt that helps much.

[Anonymous]

That is true My though was to exclude all in-appropriate year-month combinations but it did not give me the correct number.

[Anonymous]

Hi

may be you can try this !!

selecting particular date and summing

Provide : Your date field name is   "Datefield"

sum ( { $<Datefield={"2016-07-31"} >  } [accounts receivables])

or

between two dates

sum ( { $<Datefield={">=2016-07-31<=2016-08-23"} >  } [accounts receivables])