Hi,
I want to apply custom sort on calculated dimension in chart.
but, i came to know from reference manual, Sort By Expession does not work on calculated dimension.
- Is their any other way to achieve this?
Below e.g. illustrates my requirement in detail.
Two fields viz., 'Product' and 'Sub Product' need to be shown in the chart depending upon selection in the respective fields.
Hence calcualted dimension is given in chart (not able to use more than one chart because of other reasons).
- Can we give predefined sort order at loading level?
e.g.If I want to view values of field product in below sort order
'J*','C*','B*','O*','*'
how to achieve this at the time of loading the data in qlikview?
