topic Re: P function in QlikView https://community.qlik.com/t5/QlikView/P-function/m-p/1360756#M417097 <HTML><HEAD></HEAD><BODY><P>Another one could be just this</P><P><STRONG>Sum(If(User1 = User, Plan))</STRONG></P></BODY></HTML> Tue, 25 Jul 2017 11:16:41 GMT sunny_talwar 2017-07-25T11:16:41Z P function https://community.qlik.com/t5/QlikView/P-function/m-p/1360754#M417095 <HTML><HEAD></HEAD><BODY><P>Hi, everyone!</P><P>I have a model (example)</P><P></P><P></P><P>I can not configure the calculation so that the value 22 is displayed in the summary table,</P><P>The problem is that I get the amount (as in the picture)!</P><P><IMG alt="Screenshot_2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171206_Screenshot_2.png" style="height: 180px; width: 620px;" /></P><P></P><P>thanks a lot</P></BODY></HTML> Mon, 24 Jul 2017 15:30:08 GMT https://community.qlik.com/t5/QlikView/P-function/m-p/1360754#M417095 MA1 2017-07-24T15:30:08Z Re: P function https://community.qlik.com/t5/QlikView/P-function/m-p/1360755#M417096 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Sum(If(User1=User, Aggr( Sum(Plan),User,User1,KPI),0))</SPAN></P></BODY></HTML> Tue, 25 Jul 2017 08:51:41 GMT https://community.qlik.com/t5/QlikView/P-function/m-p/1360755#M417096 MA1 2017-07-25T08:51:41Z Re: P function https://community.qlik.com/t5/QlikView/P-function/m-p/1360756#M417097 <HTML><HEAD></HEAD><BODY><P>Another one could be just this</P><P><STRONG>Sum(If(User1 = User, Plan))</STRONG></P></BODY></HTML> Tue, 25 Jul 2017 11:16:41 GMT https://community.qlik.com/t5/QlikView/P-function/m-p/1360756#M417097 sunny_talwar 2017-07-25T11:16:41Z