Discussion Board for collaboration related to QlikView App Development.
Is it possible to format values of a particular field as Currency and Percentage based on specific rules?
As an example, in the attached file, the discount column in QV should display a Currency format for Product A and B, but it should display % format for Product C.
The format is determined based on Product.
You can do something like this:
If(Match(Product, 'A', 'B'), Num(Expression, '$#,##0'), Num(Expression, '##%'))