topic Re: Count of Distinct -issue in QlikView

Count of Distinct -issue

Wed, 14 Aug 2013 04:37:13 GMT

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?

Re: Count of Distinct -issue

tresB — Wed, 14 Aug 2013 04:50:55 GMT

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.

Re: Count of Distinct -issue

er_mohit — Wed, 14 Aug 2013 04:55:47 GMT

Try this way

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

Re: Count of Distinct -issue

Wed, 14 Aug 2013 05:10:50 GMT

Thanks All.

Solved it