Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulosrl
Contributor III
Contributor III

Qlikview Desktop Stacked Bar Conditional

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:

   

NAMEDATEVALUETYPE_OPERATION
A08/10/2013300C
A10/10/20131060,19C
A10/10/2013200D
b15/10/2013770C
B15/10/201325D
B16/10/201344000C
C17/10/201340000D
A17/10/20147,35D
A21/10/2014590C
B21/10/20143985,3D
B21/10/20147,35D
C22/10/2014830C
C22/10/20151000C
C22/10/2015697,73C
C22/10/2015321,8D
B22/10/2015525D
B28/10/20151870C
A29/10/2015455,95C
A29/10/2015830

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!!!

1 Solution

Accepted Solutions
jayanttibhe
Creator III
Creator III

Hi Paulo,

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

Thanks

Jayant Tibhe

View solution in original post

2 Replies
jayanttibhe
Creator III
Creator III

Hi Paulo,

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

Thanks

Jayant Tibhe

paulosrl
Contributor III
Contributor III
Author

Thanks a lot Jayant !!!