topic Value Formating in QlikView https://community.qlik.com/t5/QlikView/Value-Formating/m-p/1017055#M344556 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is it possible to format values of a particular field as Currency and Percentage based on specific rules?</P><P>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.</P><P></P><P>The format is determined based on Product.</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 25 Apr 2016 17:42:43 GMT 2016-04-25T17:42:43Z Value Formating https://community.qlik.com/t5/QlikView/Value-Formating/m-p/1017055#M344556 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is it possible to format values of a particular field as Currency and Percentage based on specific rules?</P><P>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.</P><P></P><P>The format is determined based on Product.</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 25 Apr 2016 17:42:43 GMT https://community.qlik.com/t5/QlikView/Value-Formating/m-p/1017055#M344556 2016-04-25T17:42:43Z Re: Value Formating https://community.qlik.com/t5/QlikView/Value-Formating/m-p/1017056#M344557 <HTML><HEAD></HEAD><BODY><P>You can do something like this:</P><P></P><P><STRONG>If(Match(Product, 'A', 'B'), Num(Expression, '$#,##0'), Num(Expression, '##%'))</STRONG></P></BODY></HTML> Mon, 25 Apr 2016 17:52:12 GMT https://community.qlik.com/t5/QlikView/Value-Formating/m-p/1017056#M344557 sunny_talwar 2016-04-25T17:52:12Z