topic Re: Hi in QlikView https://community.qlik.com/t5/QlikView/Hi/m-p/1288565#M871938 <HTML><HEAD></HEAD><BODY><P>With out sample app it is very difficult to give a suggestion. Any have I just created a sample app for you and attached here. So please take a look and hope this helps...</P></BODY></HTML> Tue, 22 Nov 2016 08:18:51 GMT trdandamudi 2016-11-22T08:18:51Z Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1288560#M871933 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; i have one pivot table with one month dimension and two measrures (sales1 and sales2like this</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jan&nbsp; feb&nbsp; mar&nbsp; april&nbsp; may&nbsp; jun&nbsp; july&nbsp; aug&nbsp; sep&nbsp; oct&nbsp; nov&nbsp; dec</P><P style="font-size: 13.3333px;">sales1&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 30&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 30&nbsp;&nbsp; 10&nbsp;&nbsp; 20</P><P style="font-size: 13.3333px;">sales2&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp; 60&nbsp;&nbsp; 70&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp; 20&nbsp;&nbsp; 20&nbsp; 90</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">so here i need a column at right side which adds last 3 months values for both sales1 and sales2 like this</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jan&nbsp; feb&nbsp; mar&nbsp; april&nbsp; may&nbsp; jun&nbsp; july&nbsp; aug&nbsp; sep&nbsp; oct&nbsp; nov&nbsp; dec&nbsp;&nbsp;&nbsp;&nbsp; latest_3_months</P><P style="font-size: 13.3333px;">sales1&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 30&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 30&nbsp;&nbsp; 10&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P style="font-size: 13.3333px;">sales2&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp; 60&nbsp;&nbsp; 70&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp; 20&nbsp;&nbsp; 20&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 130</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">could u please tel me...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1288560#M871933 2020-11-25T16:16:04Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1288561#M871934 <HTML><HEAD></HEAD><BODY><P>Where do you want this? In the script or UI?</P></BODY></HTML> Tue, 22 Nov 2016 07:17:59 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1288561#M871934 tresB 2016-11-22T07:17:59Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1288562#M871935 <HTML><HEAD></HEAD><BODY><P>thanku for your response... UL only (QLIKVIEW)</P></BODY></HTML> Tue, 22 Nov 2016 07:28:27 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1288562#M871935 2016-11-22T07:28:27Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1288563#M871936 <HTML><HEAD></HEAD><BODY><P>UI only (qlikview)</P></BODY></HTML> Tue, 22 Nov 2016 07:28:40 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1288563#M871936 2016-11-22T07:28:40Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1288564#M871937 <HTML><HEAD></HEAD><BODY><P>What is the dimension name for sales1, sales2 ? Could you post a sample qvw?</P></BODY></HTML> Tue, 22 Nov 2016 07:31:20 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1288564#M871937 tresB 2016-11-22T07:31:20Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/1288565#M871938 <HTML><HEAD></HEAD><BODY><P>With out sample app it is very difficult to give a suggestion. Any have I just created a sample app for you and attached here. So please take a look and hope this helps...</P></BODY></HTML> Tue, 22 Nov 2016 08:18:51 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/1288565#M871938 trdandamudi 2016-11-22T08:18:51Z