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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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, '|') & ')'