Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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!!!