Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to show the sub count of selected count

Hi Friends,

I Have a date column, in that i have selected few dates randomly. now i want to show the count of dates which is less then today of current selections selections.

I have tried Getselectedcount but it is giving count of current selections, but i want only count less then today of current selections. 

For example as per the below screen shot i have selected few dates in that i want to show the count less then today.

and count should be shown into the text box.

let say today is 04/20/2020. then my count would be 5. 

please advise how to achieve this. 

venkatbza_0-1587362658834.png

Thanks,

Venkat

2 Solutions

Accepted Solutions
Master II
Master II

=count({<tmpdate={"=tmpdate<=Today()"}>}tmpdate)

View solution in original post

Partner
Partner

Hi 

this should work for you 

=count(DISTINCT if(date<date(today(1)),date))

View solution in original post

2 Replies
Master II
Master II

=count({<tmpdate={"=tmpdate<=Today()"}>}tmpdate)

View solution in original post

Partner
Partner

Hi 

this should work for you 

=count(DISTINCT if(date<date(today(1)),date))

View solution in original post