Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatbza
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
Frank_Hartmann
Master II
Master II

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

View solution in original post

lironbaram
Partner
Partner

Hi 

this should work for you 

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

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

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

View solution in original post

lironbaram
Partner
Partner

Hi 

this should work for you 

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

View solution in original post