Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below is the Table Format, I have
Parent Column | Child Column | Total |
ABC | ABC_1 | 1 |
ABC | ABC_2 | 2 |
BCD | BCD_1 | 2 |
BCD | BCD_2 | 4 |
BCD | BCD_3 | 5 |
CDE | CDE_1 | 5 |
CDE | CDE_2 | 6 |
I want it to show in Qlikview Report like below:-
Parent Column | Total | |
ABC | 3 | |
BCD | 11 | (This is total of all childs under BCD group) |
BCD_1 | 2 | |
BCD_2 | 4 | |
BCD_3 | 5 | |
CDE | 11 |
Only BCD 's subgroup needs to be shown alongwith the total and that also in same column but with space in the starting
Regards,
Raman
I don't think there is any other way other then Pivot. Let's see if anyone has a better approach on this community, If you don't want to show '+' sign, then as I said just place a text box over the '+' sign which has the same color as the background and it will be perfect. Hope this helps...
Hi,
How cane we approach this type of design? Is this possible in Qlikview?
Regards,
Raman
Please take a look at the attached file and hope this is what you are looking for... Hope this helps...
The second table is exactly what you want. In case if you don't want to see the plus ( + ) sign, then place a text box on the top of the + sign and then you will have exactly what you want. Hope this helps...
So basically you have done it using Pivot Chart?
Isn't there any other way to do this type of representation, other than Pivot chart?
Like if I dont want to show that "+" Sign on the report.
I don't think there is any other way other then Pivot. Let's see if anyone has a better approach on this community, If you don't want to show '+' sign, then as I said just place a text box over the '+' sign which has the same color as the background and it will be perfect. Hope this helps...