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

Selecting Dates with button

Hello,

I was wondering if anyone knows how i can create a button, that selects the dates where theres more information that the average.

For example, i got my Data:

DateInfo
1A
1B
1A
2A
2B
3A
3B
4A
4B
4B
4B
5A
5A

I would like to have a button, that when i press it, it would return the selection of the dates that have more than 2.6 lines, in this case 1 and 4.

Anyone knows how i can do this?

thanks for the help,

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe an action

select in field Date

='(' & Concat({$ <Date={"=count(Date)> avg(TOTAL aggr(count(Date),Date)) "}>} distinct Date, '|') & ')'

View solution in original post

1 Reply
maxgro
MVP
MVP

maybe an action

select in field Date

='(' & Concat({$ <Date={"=count(Date)> avg(TOTAL aggr(count(Date),Date)) "}>} distinct Date, '|') & ')'