topic pivot table: how to format field values, if dimension like something? in QlikView https://community.qlik.com/t5/QlikView/pivot-table-how-to-format-field-values-if-dimension-like/m-p/854869#M299672 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>is there a possibility to change the number format if the dimension is changed by user?</P><P></P><P>Example:</P><P>if (Dimension1 = 'customers', num(column1, '# ##0,#') , num(column1, '###.#'))</P><P></P><P>I dont know where to implement and how.</P><P></P><P>Thanks and best regards</P><P>Sabrina</P></BODY></HTML> Tue, 09 Jun 2015 10:17:03 GMT 2015-06-09T10:17:03Z pivot table: how to format field values, if dimension like something? https://community.qlik.com/t5/QlikView/pivot-table-how-to-format-field-values-if-dimension-like/m-p/854869#M299672 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>is there a possibility to change the number format if the dimension is changed by user?</P><P></P><P>Example:</P><P>if (Dimension1 = 'customers', num(column1, '# ##0,#') , num(column1, '###.#'))</P><P></P><P>I dont know where to implement and how.</P><P></P><P>Thanks and best regards</P><P>Sabrina</P></BODY></HTML> Tue, 09 Jun 2015 10:17:03 GMT https://community.qlik.com/t5/QlikView/pivot-table-how-to-format-field-values-if-dimension-like/m-p/854869#M299672 2015-06-09T10:17:03Z Re: pivot table: how to format field values, if dimension like something? https://community.qlik.com/t5/QlikView/pivot-table-how-to-format-field-values-if-dimension-like/m-p/854870#M299673 <HTML><HEAD></HEAD><BODY><P>Could you share your qvw?</P></BODY></HTML> Tue, 09 Jun 2015 10:21:46 GMT https://community.qlik.com/t5/QlikView/pivot-table-how-to-format-field-values-if-dimension-like/m-p/854870#M299673 alexandros17 2015-06-09T10:21:46Z Re: pivot table: how to format field values, if dimension like something? https://community.qlik.com/t5/QlikView/pivot-table-how-to-format-field-values-if-dimension-like/m-p/854871#M299674 <HTML><HEAD></HEAD><BODY><P>Sorry, but the employer forbids sharing <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Tue, 09 Jun 2015 10:41:49 GMT https://community.qlik.com/t5/QlikView/pivot-table-how-to-format-field-values-if-dimension-like/m-p/854871#M299674 2015-06-09T10:41:49Z