topic A general pivot query in QlikView https://community.qlik.com/t5/QlikView/A-general-pivot-query/m-p/243101#M92865 <HTML><HEAD></HEAD><BODY><P> hei</P><P>just an idea</P><P>if you have other dimensions in the pivot table </P><P>you need to include them in your aggr function</P></BODY></HTML> Wed, 03 Aug 2011 05:17:11 GMT lironbaram 2011-08-03T05:17:11Z A general pivot query https://community.qlik.com/t5/QlikView/A-general-pivot-query/m-p/243100#M92864 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>The below espression works fine with a straight table, where Calendar.YearMonth is the dimension moved to the top as header. However when I change the straight table to Pivot, the AGGR part doesnt work and it simply shows the month values... Any ideas and suggestiong is highly appreciated.</P><P></P><P>=(sum(AGGR($(fnCashToMonthCV),Calendar.YearMonth)))</P><P></P><P>Thanks in Advance,</P><P>Mady</P></BODY></HTML> Tue, 02 Aug 2011 15:07:07 GMT https://community.qlik.com/t5/QlikView/A-general-pivot-query/m-p/243100#M92864 2011-08-02T15:07:07Z A general pivot query https://community.qlik.com/t5/QlikView/A-general-pivot-query/m-p/243101#M92865 <HTML><HEAD></HEAD><BODY><P> hei</P><P>just an idea</P><P>if you have other dimensions in the pivot table </P><P>you need to include them in your aggr function</P></BODY></HTML> Wed, 03 Aug 2011 05:17:11 GMT https://community.qlik.com/t5/QlikView/A-general-pivot-query/m-p/243101#M92865 lironbaram 2011-08-03T05:17:11Z