how to count all values until the current date in report

[#1]

Hello Everyone,

I need an help:

i have a pivot table which has like dimension a the ACTION_DATE and the ID of the item.

What i want to do is count all IDs where the action is NOT_DONE and the ACTION_DATE is less than the one shown in report.
So if the data shown is 4.05.2015 i want count everything until 4.05.2015 with this one excluded.
i try with this but no results for me:

     count(DISTINCT TOTAL {<ACTION={'NOT_DONE'},PRODUCT_NAME,{$1}ACTION_DATE>} ID)

Any ideas?

Thanks,

Alfonso

[sasikanth]

try some thing like this

Count(distinct {<ACTION={'NOT_DONE'}, ACTION_DATE={"<=$(=max(ACTION_DATE))"}>}ID)

[sunny_talwar]

Try this may be:

Count(DISTINCT TOTAL {<Action = {'NOT_DONE'}, ACTION_DATE = {"<$(=Date(Max({<Action = {'NOT_DONE'}>}ACTION_DATE), 'yourFormatforACTION_DATE'))"}>} ID)

[#4]

THE MAX IS NOT GOOD BECAUSE TAKE THE GREATEST DAY ONLY

[#5]

THE MAX IS NOT GOOD BECAUSE TAKE THE GREATEST DAY ONLY

Re: how to count all values until the current date in report

[Gysbert_Wassenaar]

Your Caps Lock key is broken. Please fix, kthnxbye

Try posting a qlikview document so we can see what kind of data and date fields we're dealing with.