Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am a beginner in Qlikview.I have a small query.
The scenario :
In the attached image,whenever i click the month say fr eg :JAN, the end date will be : 1/31/2013.
The Vcount should return the Count of distinct UserID where a column JoinDate value should be less than EndDate(which we get based on the selection of the month)
But I am not getting the desired output.I want to understand whether the expression for vCount is correct?
Though it seems ok, you can try with:
Count({<JoinDate={'<$(=Only(EndDate))'},Active={0}>} Distinct UserID)
If does't work, try to share your sample app.
Try this way
Count( Distinct {<JoinDate={"<$(=Test)"},Active={0}>}UserID)
Thanks All.
Solved it