Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please help me with this issue..
You could use the E() function in Qlikview
Can you share a sample of what else you have and what you trying to do? Ideally a qvw would be very helpful
check this thread for more info
PFA.
Try this:
=Count(DISTINCT {<Year>} D1D)
It doesnt work...if I have more than 1 year..
Can u apply on my application...
Please help me with this issue
Try to upload a sample with at least two year dates and expected output there.