Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

funnel chart using a range as a dimension

I have a column called sale_amount. I want to have a funnel chart that shows (by percentage) which sales are over 3000, between 2000 - 3000, between 1000 - 3000, and below 1000. So one colored area of the funnel chart would be sales over 3000 and so on. Here's an example of a funnel chart for sale_amount based off location ( blue is northeast and the others are other areas):

error loading image

so i want basically the same thing but with the ranges described above. Not sure how to do this. Maybe through a calculated dimension?

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Try to create a new dimension as : if( sale_amount < 3000 , Class( sale_amount , 1000) , '>= 3000' )

regards

jj

View solution in original post

2 Replies
Not applicable
Author

Hi,

Try to create a new dimension as : if( sale_amount < 3000 , Class( sale_amount , 1000) , '>= 3000' )

regards

jj

Not applicable
Author

perfect, thanks Jean