topic Re: how to create different bin range using class function in QlikView

how to create different bin range using class function

eliko_il — Tue, 19 Feb 2013 19:10:44 GMT

hi all,

assuming i have this table:

I want to create bar chart with x-axis as the following bin range:

<200 , 200-250, 251-300,301-350, 351-400, >400

i try the class function ( class(col2,50) ), but i need the option to create also min range (<200) and max range(>400).

In the class function it create with final range.

The y-axis just count freq of A according to the bin range.

does anyone have a solution (without change or add any data to the DB)?

thnx.

Gysbert_Wassenaar — Tue, 19 Feb 2013 19:24:01 GMT

Try something like this:

=if(Col2<200,'<200',if(Col2>400,'400',class(Col2,50)))

eliko_il — Wed, 20 Feb 2013 06:30:33 GMT

thnx Gysbert, but i still have 2 problems:

First- i want to sort the x-axis as: col2<200,200-250,251-300, .... , col2>400 i try sort by expression but it didnt work.

Second- i want to color the min col and the max col with different colors than the rest of the cols.