topic Re: Calculated Expression in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615457#M1103901 <HTML><HEAD></HEAD><BODY><P>you can do it with Pick function instead of individual expression I guess.</P><P></P><P>Ex</P><P></P><P>Pick(MetricSequence,if(condition,sum(sales)),sum(Profit),Sum(staff)) etc</P></BODY></HTML> Mon, 24 Mar 2014 17:58:52 GMT chiru_thota 2014-03-24T17:58:52Z Calculated Expression in Pivot Table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615455#M1103899 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>I have a pivot table with Sales $ in the expression and Market, Year &amp; Month as dimensions. But I would like to add a calculated expression just one time at the very end of the table and do not want it to appear against each month.</P><P></P><P>Would this be possible.</P><P></P><P></P><P>thanks</P><P>Kumar </P></BODY></HTML> Mon, 24 Mar 2014 17:36:33 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615455#M1103899 2014-03-24T17:36:33Z Re: Calculated Expression in Pivot Table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615456#M1103900 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you explain more with a sort of small example.</P><P></P><P>Thanks &amp; Regards</P></BODY></HTML> Mon, 24 Mar 2014 17:47:42 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615456#M1103900 its_anandrjs 2014-03-24T17:47:42Z Re: Calculated Expression in Pivot Table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615457#M1103901 <HTML><HEAD></HEAD><BODY><P>you can do it with Pick function instead of individual expression I guess.</P><P></P><P>Ex</P><P></P><P>Pick(MetricSequence,if(condition,sum(sales)),sum(Profit),Sum(staff)) etc</P></BODY></HTML> Mon, 24 Mar 2014 17:58:52 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615457#M1103901 chiru_thota 2014-03-24T17:58:52Z Re: Calculated Expression in Pivot Table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615458#M1103902 <HTML><HEAD></HEAD><BODY><P>do you have a screenshot or an excel sample ?</P></BODY></HTML> Mon, 24 Mar 2014 20:05:13 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-Table/m-p/615458#M1103902 srchilukoori 2014-03-24T20:05:13Z