topic funnel chart using a range as a dimension in QlikView https://community.qlik.com/t5/QlikView/funnel-chart-using-a-range-as-a-dimension/m-p/224977#M77334 <HTML><HEAD></HEAD><BODY><P>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):</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3078_sourceID:3078" /></P><P>so i want basically the same thing but with the ranges described above. Not sure how to do this. Maybe through a calculated dimension?</P></BODY></HTML> Wed, 15 Dec 2010 21:57:26 GMT 2010-12-15T21:57:26Z funnel chart using a range as a dimension https://community.qlik.com/t5/QlikView/funnel-chart-using-a-range-as-a-dimension/m-p/224977#M77334 <HTML><HEAD></HEAD><BODY><P>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):</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3078_sourceID:3078" /></P><P>so i want basically the same thing but with the ranges described above. Not sure how to do this. Maybe through a calculated dimension?</P></BODY></HTML> Wed, 15 Dec 2010 21:57:26 GMT https://community.qlik.com/t5/QlikView/funnel-chart-using-a-range-as-a-dimension/m-p/224977#M77334 2010-12-15T21:57:26Z funnel chart using a range as a dimension https://community.qlik.com/t5/QlikView/funnel-chart-using-a-range-as-a-dimension/m-p/224978#M77335 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try to create a new dimension as : if( sale_amount &lt; 3000 , Class( sale_amount , 1000) , '&gt;= 3000' )</P><P></P><P>regards</P><P>jj</P></BODY></HTML> Wed, 15 Dec 2010 22:14:16 GMT https://community.qlik.com/t5/QlikView/funnel-chart-using-a-range-as-a-dimension/m-p/224978#M77335 2010-12-15T22:14:16Z funnel chart using a range as a dimension https://community.qlik.com/t5/QlikView/funnel-chart-using-a-range-as-a-dimension/m-p/224979#M77336 <HTML><HEAD></HEAD><BODY><P>perfect, thanks Jean</P></BODY></HTML> Thu, 16 Dec 2010 14:43:49 GMT https://community.qlik.com/t5/QlikView/funnel-chart-using-a-range-as-a-dimension/m-p/224979#M77336 2010-12-16T14:43:49Z