Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Value Formating

Hello,

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.

Thanks,

Tags (2)
1 Reply

Re: Value Formating

You can do something like this:

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