topic 100% stacked chart in QlikView

100% stacked chart

Mon, 16 Nov 2009 15:11:53 GMT

Hi,

I have the following data structure ...

and i'm trying to turn them into 100% stack chart in QV

i have attached my sample file and i hope some one is able to have a solution?

Thanks,
Nick

100% stacked chart

prieper — Mon, 16 Nov 2009 15:41:52 GMT

Am not quite clear, what do you want to achieve. Can you please give some more realistic names to your Dimensions/Attributes/Values. On the first glance it seems as if the datamodel behind is a bit strange.

Peter

100% stacked chart

Mon, 16 Nov 2009 15:56:17 GMT

Hi Peter,

It's the result for a survey,

F1 = User friendly
F2 = Design
F3 = Training

and ranking is from scale of 1 to 3.

The data is already stored that way. if you open the qvw file, there's a pic to describe the data model excel needed to generate the 100% stacked chart.

but i'm trying to do it without having to modify the data structure itself, because it actually has other column link to it, it's not normalize for simplicity reason.

but you any solutions are welcome, as i'm thinking on how can i tweak the data structure i'm having.

Thanks,
Nick

100% stacked chart

prieper — Mon, 16 Nov 2009 16:22:46 GMT

But then you are missing the very first column, be it application-name or date of the poll or the like?

Peter

100% stacked chart

Tue, 17 Nov 2009 08:24:18 GMT

yes, we have other columns like : zone, country, product .. etc.

but, for now, i'm trying to see if there's any way to create a 100% stack chart without those info for simplicity, like how we can do it in excel.

do you think that's possible?

Thanks,
Nick

100% stacked chart

rwunderlich — Tue, 17 Nov 2009 09:31:45 GMT

See the attached for a possible solution.

I used CROSSTABLE to assign the the F1/F2/F3 values to each row which made creating the chart easier

I'm sure there are other solutions.

-Rob

100% stacked chart

Tue, 17 Nov 2009 10:32:11 GMT

Hi Rob,

Thanks for the solution, it's exactly what i need.

You just introduced me CROSSTABLE and the following formula ...

=Count(Rank) / Count(TOTAL<Feature> Rank)

thank you very much for your help !

Nick