topic Re: set analysis expression in QlikView https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348194#M414728 <HTML><HEAD></HEAD><BODY><P>Would you describe more, Please? </P></BODY></HTML> Wed, 05 Apr 2017 16:32:35 GMT Anil_Babu_Samineni 2017-04-05T16:32:35Z set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348193#M414727 <HTML><HEAD></HEAD><BODY><P>i need to calculate :</P><P>based on one field </P><P>U=</P><P>x-y/x+y+z</P><P></P><P>want to calculate U based on count(id)</P></BODY></HTML> Wed, 05 Apr 2017 14:51:42 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348193#M414727 Anonymous 2017-04-05T14:51:42Z Re: set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348194#M414728 <HTML><HEAD></HEAD><BODY><P>Would you describe more, Please? </P></BODY></HTML> Wed, 05 Apr 2017 16:32:35 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348194#M414728 Anil_Babu_Samineni 2017-04-05T16:32:35Z Re: set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348195#M414729 <HTML><HEAD></HEAD><BODY><P>suppose i have values for id</P><P>2</P><P>3</P><P>5</P><P>6</P><P>7</P><P>8</P><P>which are associated to field x,y and z</P><P>now i want to calculate U bsed on above formula</P><P>count of x,y,z based on id</P><P>and x,y,z are texts</P></BODY></HTML> Thu, 06 Apr 2017 03:28:30 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348195#M414729 Anonymous 2017-04-06T03:28:30Z Re: set analysis expression https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348196#M414730 <HTML><HEAD></HEAD><BODY><P>How do i know which values are associate with x,y,z over here?</P><P></P><P>May be create two columns as static and then explain business and tell us required output. So that we can tack easily. You mentioned x,y,x are texts. </P><P></P><P>May be this?</P><P></P><P><STRONG>(Count({&lt;U = {'x'}&gt;}id)-<SPAN style="font-size: 13.3333px;">Count({&lt;U = {'y'}&gt;}id)</SPAN>)/(<SPAN style="font-size: 13.3333px;">Count({&lt;U = {'x'}&gt;}id)</SPAN>+<SPAN style="font-size: 13.3333px;">Count({&lt;U = {'y'}&gt;}id)</SPAN>+<SPAN style="font-size: 13.3333px;">Count({&lt;U = {'z'}&gt;}id)</SPAN>)</STRONG></P></BODY></HTML> Thu, 06 Apr 2017 03:59:59 GMT https://community.qlik.com/t5/QlikView/set-analysis-expression/m-p/1348196#M414730 Anil_Babu_Samineni 2017-04-06T03:59:59Z