topic Re: Date Selections-Issue in QlikView

Date Selections-Issue

Mon, 26 Aug 2013 09:00:35 GMT

I need help on this :

I have four years: 2013,2012,2011,2010 and the Month columns for each.

If i click on the year 2013 and Month Jan, i should get the count of UserIds for all the months starting from Jan -1 -2010 - Jan-31- 2013.

I am trying to use the below expression .But I am not getting the desired output.MnthEndDate here for Jan will be : 2013-01-31

=Count({$ <JOIN_DATE={'<=$((MnthEndDate))'}, ACTIVE={1}, DateType = {'MEMBERS'} >} DISTINCT UserID)

Is the expression correct?

Re: Date Selections-Issue

Gysbert_Wassenaar — Mon, 26 Aug 2013 09:06:16 GMT

This should work as long as the variable MnthEndDate is a date and not just a string value and has the same date format as JOIN_DATE.
=Count({$ <JOIN_DATE={'<=$(MnthEndDate)'}, ACTIVE={1}, DateType = {'MEMBERS'} >} DISTINCT UserID)

JOIN_DATE should of course be a date too and not a string value.

Re: Date Selections-Issue

Mon, 26 Aug 2013 09:17:41 GMT

I am not getting the desired output with the above expression

Re: Date Selections-Issue

vikasmahajan — Mon, 26 Aug 2013 12:16:34 GMT

That means your transactions are not linked to master calender , Please implement master calender in your application.

As G Wassenaar Suggested this should works.

Vikas

Re: Date Selections-Issue

Mon, 26 Aug 2013 12:25:17 GMT

Hey Tks man!

it worked !!