topic Re: set analysis filling in QlikView https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58311#M782174 <HTML><HEAD></HEAD><BODY><P>Hi Sunny</P><P></P><P>what's the difference if i use single quotes?</P><P></P><P>sum(TOTAL{&lt;Letter={'C'}&gt;}price)</P></BODY></HTML> Tue, 20 Mar 2018 16:59:27 GMT shiveshsingh 2018-03-20T16:59:27Z set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58307#M782166 <HTML><HEAD></HEAD><BODY><P>Hi everyone, </P><P>Today, im stuck whithin my qlikview report <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P><P>im trying to fill one specific cell from an other one with set analysis,</P><P></P><P>Here an exemple : </P><P></P><P>Letter&nbsp;&nbsp;&nbsp;&nbsp; price&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Size&nbsp;&nbsp;&nbsp;&nbsp; price2</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tall&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...&nbsp;&nbsp; </P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Small&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...&nbsp;&nbsp;&nbsp;&nbsp; </P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>what i wanna do is to fill the fourth column with the second column value of C (50) like :</P><P></P><P>Letter&nbsp;&nbsp;&nbsp;&nbsp; price&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Size&nbsp;&nbsp;&nbsp;&nbsp; price2</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tall&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">50</SPAN></P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Small&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">50</SPAN></P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> Thin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">50</SPAN></P><P></P><P>So i tried this set analysis whitout any succes : </P><P>Sum({$&lt;[Letter]={"C"}&gt;} [price])</P><P></P><P>Does anyone get the same issue ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58307#M782166 Anonymous 2020-11-25T16:16:04Z Re: set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58308#M782167 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Sum(<SPAN style="color: #ff0000;">TOTAL</SPAN> {$&lt;[Letter]={"C"}&gt;} [price])</STRONG></P></BODY></HTML> Tue, 20 Mar 2018 16:52:13 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58308#M782167 sunny_talwar 2018-03-20T16:52:13Z Re: set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58309#M782168 <HTML><HEAD></HEAD><BODY><P>may be this&nbsp; qualifier ?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">Sum(Total {$&lt;[Letter]={"C"}&gt;} [price])</SPAN></P></BODY></HTML> Tue, 20 Mar 2018 16:54:46 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58309#M782168 Chanty4u 2018-03-20T16:54:46Z Re: set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58310#M782169 <HTML><HEAD></HEAD><BODY><P>Try this :&nbsp; sum(TOTAL{&lt;Letter={'C'}&gt;}price)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196907_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 20 Mar 2018 16:58:47 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58310#M782169 shiveshsingh 2018-03-20T16:58:47Z Re: set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58311#M782174 <HTML><HEAD></HEAD><BODY><P>Hi Sunny</P><P></P><P>what's the difference if i use single quotes?</P><P></P><P>sum(TOTAL{&lt;Letter={'C'}&gt;}price)</P></BODY></HTML> Tue, 20 Mar 2018 16:59:27 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58311#M782174 shiveshsingh 2018-03-20T16:59:27Z Re: set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58312#M782177 <HTML><HEAD></HEAD><BODY><P>In this case, none... but I think single quote is preferable... but for a search statement like this {"C*"}.. I would use double quotes because of the new Quotology&nbsp; <A href="https://community.qlik.com/qlik-blogpost/5335">Quotes in Set Analysis</A>‌</P></BODY></HTML> Tue, 20 Mar 2018 17:02:51 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58312#M782177 sunny_talwar 2018-03-20T17:02:51Z Re: set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58313#M782180 <HTML><HEAD></HEAD><BODY><P>Okie, thanks</P></BODY></HTML> Tue, 20 Mar 2018 17:17:31 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58313#M782180 shiveshsingh 2018-03-20T17:17:31Z Re: set analysis filling https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58314#M782181 <HTML><HEAD></HEAD><BODY><P>Thanks you guys, everythings is fine now <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 21 Mar 2018 08:50:40 GMT https://community.qlik.com/t5/QlikView/set-analysis-filling/m-p/58314#M782181 Anonymous 2018-03-21T08:50:40Z