topic combo chart issue in QlikView

combo chart issue

Mon, 19 Dec 2011 09:54:58 GMT

Hi,

One chart is having 2 dimension values and 2 expressions i want to show these values in combo chart. Its working fine for 1 dimension and 2 expressions, but if i added 2nd dimension to same chart then dimensions are over lopping each other and i have more number of dimensins also,after selecting stacked option from chart properties also its not working. So please help how to resolve this issue..

combo chart issue

jagan — Mon, 19 Dec 2011 11:30:13 GMT

Hi Anil,

Can you attach sample file.

Regards,

Jagan.

combo chart issue

Mon, 19 Dec 2011 12:09:29 GMT

Hi Jagan, am not able to up load the sample file i am just attaching the sample screen shot of that combo chart , in below chart 2 dimension (Loc) would be as stacked but the stacked option is disbaled here, how to do that here.

please use this as sample data ,, Manager, Loc are the 2 dimensions and Appl,DB are 2 expressions... i think this may give you a idea....

LOAD * INLINE [

Manager, Appl, DB, Loc

HONNILA, AMPS Assembly, Oracle, ABC

HONNILA, AMPS Assembly, Oracle, DEF

MICHAEL, Dealer Business Management, DB2, DEF

MICHAEL, Dealer Business Management, DB2, GHI

ANTHONY, Capacity and Option Planning System, Sybase, GHI

ANTHONY, Capacity and Option Planning System, Sybase, XYZ

DAVID, Collaboration Database, Gateway , XYZ

];

Re: combo chart issue

jagan — Mon, 19 Dec 2011 13:54:55 GMT

Hi Anil,

Please find the attachment. Hope this helps you.

Regards,

Jagan.

combo chart issue

Mon, 19 Dec 2011 14:40:34 GMT

Jagan thnx for replay, In bar chart if we have two dimenisons one expression we can apply the stacked option. My req is i have 2 dimensions and 2 expressions for this i want to use combo chart with stacked option as per my customer req how can we do this.

In our above example inline table is having 4 mangaers but in above chart we can see 2 managers only and either of the dimension should be stacked. Below is the chart for 2 dimensions and 1 expression from this same chart i want to add one more expression like count(Appl) and either of the dimension should be stacked like below screenn shot...

combo chart issue

jagan — Tue, 20 Dec 2011 13:30:17 GMT

Hi,

I tried it, but when we add the second expression the chart is not working correctly as expected. Try adding second expression and group the two expressions, in that way you can toggle between the two expressions. In one chart it is not rendering correctly.

Regards,

Jagan.