Hi,
In qlik sense data displaying in Pivot table
i'm giving the example table like
| Week1 | Week2 | Week3 | | |
Lob | 23423 | 786 | 9897 | | |
Customer proj | 78686 | 7868 | 08 | | |
Non Cust Proj | 675 | 5757 | 979 | | |
Bench | 756765 | 65 | 86786 | | |
Apps &SI | 363 | 989 | 897 | | |
Customer proj | 76 | 8787 | 67 | | |
Non Cust Proj | 434 | 3434 | 767 | | |
Bench | 878 | 090 | 545 | | |
| | | | | |
1)i want display the one color for LOB,
2)under LOB i have Customer,Non Customer,Bench ( i want to display the different color for these 3 values)
3) under Customer again i have TnM and Non TnM ( i want to display the different color for these 2 values)
Like this i have 5 rows hierarchy .
please help me on this
With best regards,
Pradeep K.