Hello there. I'm using Qlik Sense Desktop with a .csv as my data file.
I'm working on a folder where every chart is based on the Top 100 Events by Region ID.
My CSV looks like this (has many more columns)
Driver_Name
Region_ID
Vehicle_Type
Company
Safe Speed Threshold
Offense_ID
Mark
3034
Truck
Beer-AAA
> 80%
1
Mark
3034
Truck
Beer-AAA
> 90%
1
Paul
7001
3/4
Soda-BBB
> 80%
2
John
7020
Truck
Beer-ABA
> 80%
3
Chris
3670
3/4
Soda-BBB
> 80%
4
Chris
3670
3/4
Soda-BBB
> 90%
4
Chris
3670
3/4
Soda-BBB
> 95%
4
In the chart were I listen the number of events (count of offense_id) by region ID is easy to do that, but I can't apply this filter to other charts because region ID is not a metric or attribute of these. How can I do that?
I've tried to use Aggr(If(Rank(Count(Offense_ID), 1, 0) <= 100, Region_ID), Region_ID), but nothing happens. The charts I want to add this filters are: map (where the point size uses the Count(id)), bar graphics (number of events per Company, per Vehicle Type and per Safe Speed Threshold) and tables (number of events by Driver, for example).
