Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Value Formating


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.


Tags (2)
1 Reply

Re: Value Formating

You can do something like this:

If(Match(Product, 'A', 'B'), Num(Expression, '$#,##0'), Num(Expression, '##%'))