topic Add a dimension in Pivot Table based on two fields in QlikView https://community.qlik.com/t5/QlikView/Add-a-dimension-in-Pivot-Table-based-on-two-fields/m-p/718149#M258088 <HTML><HEAD></HEAD><BODY><P>I would like to add a Dimension in a Pivot Table which is based on two other Dimensions values. Syntax if the following</P><P></P><P>If([Corporate Account]='OTHER', [Sales Account], [Corporate Account])</P><P></P><P>If the Corporate Account for the cell is Other, I would like the dimension's value to be Sales Account, and else Corporate Account.</P><P></P><P>I suspect that [Sales Account] is the name of the field, but does not refer to the value of the field for one very cell. Same with [Corporate Account]. How can I refer to the value of the Dimension [Sales Account] or [Corporate Account] for one very cell in pivot table ?</P><P></P><P>What is wrong with this syntax ?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Sat, 05 Jul 2014 10:38:43 GMT 2014-07-05T10:38:43Z Add a dimension in Pivot Table based on two fields https://community.qlik.com/t5/QlikView/Add-a-dimension-in-Pivot-Table-based-on-two-fields/m-p/718149#M258088 <HTML><HEAD></HEAD><BODY><P>I would like to add a Dimension in a Pivot Table which is based on two other Dimensions values. Syntax if the following</P><P></P><P>If([Corporate Account]='OTHER', [Sales Account], [Corporate Account])</P><P></P><P>If the Corporate Account for the cell is Other, I would like the dimension's value to be Sales Account, and else Corporate Account.</P><P></P><P>I suspect that [Sales Account] is the name of the field, but does not refer to the value of the field for one very cell. Same with [Corporate Account]. How can I refer to the value of the Dimension [Sales Account] or [Corporate Account] for one very cell in pivot table ?</P><P></P><P>What is wrong with this syntax ?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Sat, 05 Jul 2014 10:38:43 GMT https://community.qlik.com/t5/QlikView/Add-a-dimension-in-Pivot-Table-based-on-two-fields/m-p/718149#M258088 2014-07-05T10:38:43Z