Pivot Table Sorting Issue

Anonymous — Wed, 15 May 2013 18:50:22 GMT

Hi All,

we want to display below mentioned data into single pivot table with a column name called produc name which is either Fund Or Cap depending on Vehilce along with the sort order mentioned in respecitve columns either Fund Sort Order Or .Cap Sort Order. depending on vehicle. Please find the qlikview app as an attachment. Some how this sort is not working after we configure sort using expression.

Vehicle	Group	Cap	Fund	Fund Sort Order	Cap Sort Order
MF	offer1		Fund1	1
MF	offer2		Fund2	2
MF	offer1		Fund3	3
MF	offer2		Fund4	4
MA	offer3	Cap1			5
MA	offer3	Cap2			6
MA	offer4	Cap3			7
IA	Offer5	Cap5			8
IA	Offer5	Cap1			9
IA	Offer5	Cap4			10
INS	Offer6	Cap1			11
INS	Offer6	Cap4			12

Dimensions: I have used are below:

Vehicle

Group

=if(Vehicle ='MF',Fund,Cap)

Sort Order All the dimensions:

= if(Vehicle ='MF',[Fund Sort Order],[Cap Sort Order])

Sort order is not working as per expected.. Please find the attached qlikview app along with the data in excel.

topic Pivot Table Sorting Issue in QlikView

Pivot Table Sorting Issue