Grouped & Stacked Bar chart in same graph

kiranpatil123 — Sun, 07 Jul 2019 18:39:19 GMT

Hi All ,

I have below Graph as Stack bar chart which has 6 different expression with no dimension .

Requirement is to merge the 3 expression into 1 grouped Bar ie . I'm showing in 3 different cuts 11 , 108 and 97 . i want to

as 1 grouped Bar ( with 2 colors ) 97+11 = 108 and the remaining should be show as same stack bar .

Please help . I believe something to do with syntactic dimesion ( value list or value loop ) or any method.

Advance thanks

Re: Grouped & Stacked Bar chart in same graph

qliksus — Mon, 08 Jul 2019 11:50:16 GMT

Create a inline table like the below

LOAD * INLINE [
dim, dim1, amount
exp1, , 54
exp2, exp2, 11
exp2, exp3, 108
exp2, exp4, 97
exp5, , 213
exp6, , 195
];

And take Dim1,Dim2 in the chart as dimension and the respective expression for each dimension and select the stacked bar option in the bar chart