Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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,

1 Reply
sunny_talwar

You can do something like this:

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