topic Re: Pivot Table use dimension as an expression in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371313#M419128 <HTML><HEAD></HEAD><BODY><P>May be there are more than one values... to check if this is true or not, try this</P><P><STRONG>Concat(DISTINCT [Course Title], ', ')</STRONG></P></BODY></HTML> Wed, 14 Jun 2017 16:37:07 GMT sunny_talwar 2017-06-14T16:37:07Z Pivot Table use dimension as an expression https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371312#M419127 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For a particular use case in my dashboard, I need to use a dimension as an expression in a pivot table, but when I use the dimension as an expression I don't get any results. For example: a dimension [Course Title] displays vale 'abc' when used as a dimension but when I used the same dimension as an expression using the formula =[Course Title], I get only '-'</P><P></P><P>Kindly advise!</P></BODY></HTML> Wed, 14 Jun 2017 16:27:34 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371312#M419127 2017-06-14T16:27:34Z Re: Pivot Table use dimension as an expression https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371313#M419128 <HTML><HEAD></HEAD><BODY><P>May be there are more than one values... to check if this is true or not, try this</P><P><STRONG>Concat(DISTINCT [Course Title], ', ')</STRONG></P></BODY></HTML> Wed, 14 Jun 2017 16:37:07 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371313#M419128 sunny_talwar 2017-06-14T16:37:07Z Re: Pivot Table use dimension as an expression https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371314#M419129 <HTML><HEAD></HEAD><BODY><P>Still does not work</P></BODY></HTML> Wed, 14 Jun 2017 16:39:04 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371314#M419129 2017-06-14T16:39:04Z Re: Pivot Table use dimension as an expression https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371315#M419130 <HTML><HEAD></HEAD><BODY><P>You have only one Expression in Pivot Table. If it is string you must check the Suppress from Presentation tab</P></BODY></HTML> Wed, 14 Jun 2017 16:42:10 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371315#M419130 Anil_Babu_Samineni 2017-06-14T16:42:10Z Re: Pivot Table use dimension as an expression https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371316#M419131 <HTML><HEAD></HEAD><BODY><P>Can you show us what you are seeing?</P></BODY></HTML> Wed, 14 Jun 2017 16:55:27 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-use-dimension-as-an-expression/m-p/1371316#M419131 sunny_talwar 2017-06-14T16:55:27Z