Hi, I'm totally new to Qlik sense and need some help creating a Filter. The data I have is along the lines of looking at ticket times for example:
Ticket No | Ticket Time (hhh:mm:ss) | Rank
12345 | 00:30:00 | 1
67890 | 00:10:00 | 2
I have a table on my dash that shows this information sorted by highest to lowest. There are approx 100 plus tickets in this table. Ive also added a rank column using "Rank(TOTAL Ticket Time, 4)"
Id like to make a filter that just updates the dashboard to show two parameters. The five percent outliers via the highest times and the remaining 95 percent. Ive created a slider that links two variable that are formulated:
count(total Ticket Time)*0.05
count(total Ticket Time)*0.95
Id like to then have a button that would simply update the Dashboard to show either one of these variables depending on what you selected on the slider. If thats not possible then two buttons would suffice. One for each parameter.
Any help on this is appreciated.
