Count of Distinct -issue

[#1]

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?

[tresesco]

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.

[er_mohit]

Try this way

Count( Distinct {<JoinDate={"<$(=Test)"},Active={0}>}UserID)

[#4]

Thanks All.

Solved it