How to get excluded count of dates on selection of the month

[mohammadkhatimi]

I have list of dates which should be taken as count if the dates is not passed and also the dates are passed.

I want to put this in formula.

For e.g

11/04/2016, 14/04/2016, 15/04/2016,16/04/2015  is the list of dates.

I want two expressions which will count for the dates passed + all the dates in the list as you can see above.

Also my dates are linked to Master Calendar.

sunindia‌

Please help me with this issue..

[avinashelite]

You could use the E() function in Qlikview

[sunny_talwar]

Can you share a sample of what else you have and what you trying to do? Ideally a qvw would be very helpful

[avinashelite]

check this thread for more info

P() and E() in set analysis expression

[mohammadkhatimi]

PFA.

[sunny_talwar]

Try this:

=Count(DISTINCT {<Year>} D1D)

[mohammadkhatimi]

It doesnt work...if I have more than 1 year..

[mohammadkhatimi]

Can u apply on my application...

[mohammadkhatimi]

swuehl‌

Please help me with this issue

[tresesco]

Try to upload a sample with at least two year dates and expected output there.