topic Re: set analysis - table in QlikView https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624262#M1109599 <HTML><HEAD></HEAD><BODY><P>tnx!!</P><P></P><P>its working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 12 Mar 2014 06:36:51 GMT adiarnon 2014-03-12T06:36:51Z set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624251#M1109586 <HTML><HEAD></HEAD><BODY><P>hi i have a table-</P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54724_Capture.PNG.png" style="width: 620px; height: 433px;" /></P><P>because of the set analysis in column(6) i see in the table all the product types (first column) .</P><P>i want to see only the type with the full data (if i removing the set analysis in the 6 expression its show only the products type i want)</P><P></P><P>hope im clear...</P></BODY></HTML> Tue, 11 Mar 2014 13:05:44 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624251#M1109586 adiarnon 2014-03-11T13:05:44Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624252#M1109587 <HTML><HEAD></HEAD><BODY><P>Please write your set analysis and explain your needed conditions</P></BODY></HTML> Tue, 11 Mar 2014 13:09:16 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624252#M1109587 alexandros17 2014-03-11T13:09:16Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624253#M1109588 <HTML><HEAD></HEAD><BODY><P>Please write your set expression to have look at</P></BODY></HTML> Tue, 11 Mar 2014 13:14:47 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624253#M1109588 upaliwije 2014-03-11T13:14:47Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624254#M1109589 <HTML><HEAD></HEAD><BODY><P>no, you are not clear</P></BODY></HTML> Tue, 11 Mar 2014 13:15:12 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624254#M1109589 2014-03-11T13:15:12Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624255#M1109590 <HTML><HEAD></HEAD><BODY><P>Can you be more specific in your requirements?</P></BODY></HTML> Tue, 11 Mar 2014 13:35:11 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624255#M1109590 MK_QSL 2014-03-11T13:35:11Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624256#M1109591 <HTML><HEAD></HEAD><BODY><P>my table with the set analysis expression- </P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54736_Capture.PNG.png" style="width: 620px; height: 439px;" /></P><P>my table without the set analysis expression-</P><P></P><P><IMG alt="Capture1.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54737_Capture1.PNG.png" style="width: 620px; height: 301px;" /></P><P>the set analysis expression make the table to include all the values of the dimension.</P><P>i want the date of the table with the set analysis expression but to see only part of the values of the dimension</P><P>(like in the second table)</P><P></P><P>its hard for me to explain...</P></BODY></HTML> Tue, 11 Mar 2014 14:39:11 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624256#M1109591 adiarnon 2014-03-11T14:39:11Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624257#M1109592 <HTML><HEAD></HEAD><BODY><P>can someone help?</P></BODY></HTML> Tue, 11 Mar 2014 14:56:38 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624257#M1109592 adiarnon 2014-03-11T14:56:38Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624258#M1109593 <HTML><HEAD></HEAD><BODY><P>include your expression into a <STRONG>aggr</STRONG>() function</P><P><STRONG>aggr</STRONG>(sum{set analysis} measure), dim1, dim2)</P><P>where dim1 and dim2 are the dimension (in that order) of your table</P><P></P><P>Fabrice</P></BODY></HTML> Tue, 11 Mar 2014 15:08:23 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624258#M1109593 2014-03-11T15:08:23Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624259#M1109594 <HTML><HEAD></HEAD><BODY><P>tnx,</P><P>its working.</P><P>but is there a way to see the partial sum (totals?)...</P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54738_Capture.PNG.png" style="width: 620px; height: 345px;" /></P></BODY></HTML> Tue, 11 Mar 2014 15:25:44 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624259#M1109594 adiarnon 2014-03-11T15:25:44Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624260#M1109595 <HTML><HEAD></HEAD><BODY><P>add an additional sum before your aggr, sum(aggr(sum...)</P></BODY></HTML> Tue, 11 Mar 2014 15:28:01 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624260#M1109595 michael_maeuser 2014-03-11T15:28:01Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624261#M1109597 <HTML><HEAD></HEAD><BODY><P>Encapsulate once again the <STRONG>aggr</STRONG>() with a <STRONG>sum</STRONG>()</P><P>sum(aggr(sum ....</P><P></P><P>Fabrice</P></BODY></HTML> Tue, 11 Mar 2014 15:36:55 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624261#M1109597 2014-03-11T15:36:55Z Re: set analysis - table https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624262#M1109599 <HTML><HEAD></HEAD><BODY><P>tnx!!</P><P></P><P>its working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 12 Mar 2014 06:36:51 GMT https://community.qlik.com/t5/QlikView/set-analysis-table/m-p/624262#M1109599 adiarnon 2014-03-12T06:36:51Z