topic Dimension/Expression question in pivot table chart in QlikView https://community.qlik.com/t5/QlikView/Dimension-Expression-question-in-pivot-table-chart/m-p/222310#M74990 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have a scenario like this:</P><P>I want to display sales pivoted by customer(X) and year(Y) - two dimensions I have. The figure I use as formula is =SUM(SalesAmount).</P><P>In addition - I would like to display several more fields from the customer - such as Customer Code, Customer Currency, Customer Phone and so on.</P><P>Those fields are not exactly dimensions, since there is only one for each customer - so I want them to be shown always when customer dimension is expanded - so I cant just add them as dimension</P><P>Those fields are not exacly expressions - If I add them as an expression, they will be replicated several times which is also no good.</P><P>If I make a calculated dimension composed of several fields, or create a new concatenated field on the structure level - it doesn't look good and cant be exported to excel properly.</P><P></P><P>Is there any proper solution to this rather typical scenario?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Jan 2010 12:15:40 GMT m4u 2010-01-26T12:15:40Z Dimension/Expression question in pivot table chart https://community.qlik.com/t5/QlikView/Dimension-Expression-question-in-pivot-table-chart/m-p/222310#M74990 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I have a scenario like this:</P><P>I want to display sales pivoted by customer(X) and year(Y) - two dimensions I have. The figure I use as formula is =SUM(SalesAmount).</P><P>In addition - I would like to display several more fields from the customer - such as Customer Code, Customer Currency, Customer Phone and so on.</P><P>Those fields are not exactly dimensions, since there is only one for each customer - so I want them to be shown always when customer dimension is expanded - so I cant just add them as dimension</P><P>Those fields are not exacly expressions - If I add them as an expression, they will be replicated several times which is also no good.</P><P>If I make a calculated dimension composed of several fields, or create a new concatenated field on the structure level - it doesn't look good and cant be exported to excel properly.</P><P></P><P>Is there any proper solution to this rather typical scenario?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Jan 2010 12:15:40 GMT https://community.qlik.com/t5/QlikView/Dimension-Expression-question-in-pivot-table-chart/m-p/222310#M74990 m4u 2010-01-26T12:15:40Z Dimension/Expression question in pivot table chart https://community.qlik.com/t5/QlikView/Dimension-Expression-question-in-pivot-table-chart/m-p/222311#M74991 <HTML><HEAD></HEAD><BODY><P>Never mind, got it</P></BODY></HTML> Sun, 31 Jan 2010 12:38:51 GMT https://community.qlik.com/t5/QlikView/Dimension-Expression-question-in-pivot-table-chart/m-p/222311#M74991 m4u 2010-01-31T12:38:51Z Dimension/Expression question in pivot table chart https://community.qlik.com/t5/QlikView/Dimension-Expression-question-in-pivot-table-chart/m-p/222312#M74992 <HTML><HEAD></HEAD><BODY><P>And the answer is.....???</P></BODY></HTML> Tue, 21 Dec 2010 18:36:59 GMT https://community.qlik.com/t5/QlikView/Dimension-Expression-question-in-pivot-table-chart/m-p/222312#M74992 2010-12-21T18:36:59Z