Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Selections-Issue

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?

1 Solution

Accepted Solutions
vikasmahajan

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.



talk is cheap, supply exceeds demand
Not applicable
Author

I am not getting the desired output with the above expression

vikasmahajan

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Hey Tks man!

it worked !!