Qlikview Desktop Stacked Bar Conditional

[paulosrl]

Hi guys,

I'm starting wiyth Qlikview. Could you help me to create a Stacked Bar, maybe its use conditional expression.

My table in excel have 4 columns

like this:

NAME	DATE	VALUE	TYPE_OPERATION
A	08/10/2013	300	C
A	10/10/2013	1060,19	C
A	10/10/2013	200	D
b	15/10/2013	770	C
B	15/10/2013	25	D
B	16/10/2013	44000	C
C	17/10/2013	40000	D
A	17/10/2014	7,35	D
A	21/10/2014	590	C
B	21/10/2014	3985,3	D
B	21/10/2014	7,35	D
C	22/10/2014	830	C
C	22/10/2015	1000	C
C	22/10/2015	697,73	C
C	22/10/2015	321,8	D
B	22/10/2015	525	D
B	28/10/2015	1870	C
A	29/10/2015	455,95	C
A	29/10/2015	830	C

I need a vertical stacked bar that use

like this

NAME X TYPE_OPERATION

A - SUM(C) - SUMD(D) -TOTAL(C+D)

B - SUM(C) - SUMD(D) -TOTAL(C+D)

C - SUM(C) - SUMD(D) -TOTAL(C+D)

Thanks a lot!!!

[jayanttibhe · Accepted solution]

Hi Paulo,

Please find attached.  Please note : You can remove the date Dim if you dont need that.

Thanks

Jayant Tibhe

[paulosrl]

Thanks a lot Jayant !!!