Discussion Board for collaboration related to QlikView App Development.
Hi I have attached a sample snapshot where I have to add the two rows values of hierarchy level 00 and 01 and 05 and 06. How to do so?
so that I will be sorting my data like
Add Rows on Pivot Tables
very very important....how to add a row in pivot table
Use a calculated dimension;
If(Match(HierarchyLevel, '00', '01', Dual('00-01', 0),
If(Match(HierarchyLevel, '05', '06', Dual('05-06', 1000), HierarchyLevel))