Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammadkhatimi
Partner
Partner

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

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..

16 Replies
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
Partner
Partner
Author

PFA.

sunny_talwar

Try this:

=Count(DISTINCT {<Year>} D1D)

mohammadkhatimi
Partner
Partner
Author

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

mohammadkhatimi
Partner
Partner
Author

Can u apply on my application...

mohammadkhatimi
Partner
Partner
Author

swuehl

Please help me with this issue

tresesco
MVP
MVP

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