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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Amount of hours by month with >350

Hi Expert

I have  distribuate hours and tickets for parking, as you see in the screen , i have select one MONTH, and one DAY and i see the amount of tickets for this day, this month.

if the amount of tickets is >350, i paint it black

But i want to calculate and see in a char , the number of hours that i have more than 350 in the whole MONTH, not only in the day

for example:

in october , i have only one with more than >350, i wan to see a bar chart, that show Octobre with only 1 item

but if in november i have 5 hours wiht more than 350, i want to see teh bar chart with november and 5 items count

attached  a qvw with example and image to show

thank you a lot expert

Fernando K.

1 Solution

Accepted Solutions
eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Fernando

If you create a bar chart with %MesAño as the Dimension and

    =sum(aggr(if(count(Ticketnumber)>350,1,0),%MesAño,[Dia Mes],FranjaHorarioParking))

as the expression, I thik you'll have what you need

Eduardo

Tickets350.JPG

View solution in original post

2 Replies
marcus_sommer

Maybe a calculated dimension - in chart or listbox - like:

aggr(class(count(Hour), 100 /* or more flexible with a variable like $(vHourCluster) */), Hour)

is a useful approach or a set analysis filter like:

count({< Hour = {"=count(Hour) > 350"} >} Hour)

- Marcus

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Fernando

If you create a bar chart with %MesAño as the Dimension and

    =sum(aggr(if(count(Ticketnumber)>350,1,0),%MesAño,[Dia Mes],FranjaHorarioParking))

as the expression, I thik you'll have what you need

Eduardo

Tickets350.JPG