topic Re: How to create a classify chart in QlikView

How to create a classify chart

Thu, 19 Mar 2015 03:17:59 GMT

Hi all,

I need to create a table like this. The main question is about the column 'Group' and 'Name' which are the dimension. How to do that?

Group	Name	Sale percentile	Sales
Group 1	Tom	10%	1
Group 1	Lily	30%	3
Group 2	Jon	20%	2
Group 3	Will	40%	4

Thanks.

Jelly

Thu, 19 Mar 2015 03:24:46 GMT

I think you can use the pivot from the charts.

arulsettu — Thu, 19 Mar 2015 03:25:36 GMT

post your data source

its_anandrjs — Thu, 19 Mar 2015 03:28:59 GMT

Hi,

Definitely you can use Pivot Chart here due to your requirement.

Regards

Anand

Thu, 19 Mar 2015 03:34:59 GMT

Hi,

Yes the pivot table is useful. And how could I remove the plus sign from the table so that it will not show in report?

rwunderlich — Thu, 19 Mar 2015 03:59:43 GMT

On the Presentation Pane, check "Always full expanded". That will remove the +/- icons.

-Rob

hariprasadqv — Thu, 19 Mar 2015 03:59:55 GMT

Hi,

use pivot table. It will take care of the format.

Thu, 19 Mar 2015 04:31:12 GMT

Thanks so much!