Discussion Board for collaboration related to QlikView App Development.
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!!!
Hi Paulo,
Please find attached. Please note : You can remove the date Dim if you dont need that.
Thanks
Jayant Tibhe
Hi Paulo,
Please find attached. Please note : You can remove the date Dim if you dont need that.
Thanks
Jayant Tibhe
Thanks a lot Jayant !!!