topic Counterpart values for different months in QlikView https://community.qlik.com/t5/QlikView/Counterpart-values-for-different-months/m-p/1358937#M416751 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have an issue like a have a pivot table which represents data according to three months. Currecnt(whichever is selected), previous month, and previous to previous month.</P><P>I have several hierarchy of dimensions. For these three months i have taken an inline field M,M-1,M-2 so accrdingly iahve taken if condition for every expresion.</P><P></P><P>Now the issue is that the table is showing only those dimension rows which are associated with the month selected i.e. M.</P><P>So if we dont have values for M for any expression then it will not show in the pivot chart only instead of that expressions has values for previous or previous to previous month.</P><P></P><P>So, the sum of Rows is always lesser than expression total for M-1 &amp; M-2.</P><P></P><P>Please revert to me if any more info you need. Help me with this issue. Any lead will be appreciated.</P></BODY></HTML> Wed, 03 May 2017 14:10:52 GMT shanky1907 2017-05-03T14:10:52Z Counterpart values for different months https://community.qlik.com/t5/QlikView/Counterpart-values-for-different-months/m-p/1358937#M416751 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have an issue like a have a pivot table which represents data according to three months. Currecnt(whichever is selected), previous month, and previous to previous month.</P><P>I have several hierarchy of dimensions. For these three months i have taken an inline field M,M-1,M-2 so accrdingly iahve taken if condition for every expresion.</P><P></P><P>Now the issue is that the table is showing only those dimension rows which are associated with the month selected i.e. M.</P><P>So if we dont have values for M for any expression then it will not show in the pivot chart only instead of that expressions has values for previous or previous to previous month.</P><P></P><P>So, the sum of Rows is always lesser than expression total for M-1 &amp; M-2.</P><P></P><P>Please revert to me if any more info you need. Help me with this issue. Any lead will be appreciated.</P></BODY></HTML> Wed, 03 May 2017 14:10:52 GMT https://community.qlik.com/t5/QlikView/Counterpart-values-for-different-months/m-p/1358937#M416751 shanky1907 2017-05-03T14:10:52Z