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.