I have a list of KPIs as a dimension. Which have various kinds of metrics like Totals, Costs, Percentages etc. I need to format the data based on the kind. For example, if KPI is related to cost, i need '$ #,###' as format and if Percentage '#.##%' ... using if else .. in the expression will do, but if I have many variations like above, it becomes complicated.
I have tried with keeping a column with the symbols to be added and appended it using (DataValue)&Wildcard. But this fails when the DataValue is null or empty.
Can we achieve this in QlikView? Or else is there any work around.
