Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude values from a dimension in a chart object

I have a line chart with a dimension called BookingHour (with values 1 - 23) and an expression called Sum(Tickets). Is there a way to exclude certain values from BookingHour? I would like to only display values 7 - 23 in the chart.

Thank you.

1 Solution

Accepted Solutions
skaredovs
Partner - Creator
Partner - Creator

Hi!

sum(if(BookingHour>=7 and BookingHour<=23,Tickets))


Best regards,

Konstantins

View solution in original post

3 Replies
skaredovs
Partner - Creator
Partner - Creator

Hi!

sum(if(BookingHour>=7 and BookingHour<=23,Tickets))


Best regards,

Konstantins

Not applicable
Author

Just figured it out. In the Axes tab of the Chart Properties box, I changed the Dimension Axis to Continuous. This allowed me to customise the Scale settings. So I entered Static Min = 7, Static Max = 23, Static Step = 1.

Not applicable
Author

Hi Konstantins,

I just tried your suggestion and it also works. Actually, I prefer your line of code over changing the Chart Properties as I mentioned earlier. Thanks very much for your quick reply!!!