topic Stacked Chart Problem in QlikView

Stacked Chart Problem

Fri, 31 Aug 2012 09:16:50 GMT

Hi All,

I am 6 Metrics..................Such as

METRIC1, metric2,

METRIC3, metric4,

METRIC5, metric6

I want to have 3 bar charts such as metric2 lie above METRIC1 (in stack form)

similarly, metric4 above METRIC3 and so on............

I have attached the snapshot of the requirement............Plz see it.

How to acheive this................

Fri, 31 Aug 2012 10:16:33 GMT

try

=Pick(Match(metric, 'metric1','metric2','metric3','metric4','metric5','metric6'), 'one', 'one','two','two','three','three')

as a dimension

Fri, 31 Aug 2012 10:40:07 GMT

Hi Pari,

Thanx for reply.............

What is metric here?

And in expression, I will put the 6 metrics ??

Plz Suggest................

Fri, 31 Aug 2012 10:43:49 GMT

metric is a field name containing all of your metrics (1 to 6)

see att file

Fri, 31 Aug 2012 11:00:49 GMT

Thanx for reply again,

These 6 metrics are coming from database as separate fields and I m rolling up the data(Values) of these metrics(Fields) to obtain the result.

So I cannot have separate field and keep those metrics in it.

Is there any other approach ??

Thanx Again

Fri, 31 Aug 2012 11:12:00 GMT

check this

Fri, 31 Aug 2012 11:15:57 GMT

or check this one (second chart)

Fri, 31 Aug 2012 12:12:40 GMT

Superb !! Thanx a Alot Pari...........What An Idea...............