topic Re: Conditional in QlikView https://community.qlik.com/t5/QlikView/Conditional/m-p/1412030#M812013 <HTML><HEAD></HEAD><BODY><P>Not exactly, as I need to add more dimensions... i.e. customers... It's just about the formula of the amounts:</P><P></P><P>I used Sum ({&lt;Origen = subfield(GetFieldSelections(Origen,'||'),'||',1)&gt;}[Amount]) but it's gives an error.</P><P></P><P><SPAN style="font-size: 13.3333px;">subfield(GetFieldSelections(Origen,'||'),'||',1) gives the first selected origen, but I'm not able to get the conditional sum correct using this value...</SPAN></P></BODY></HTML> Mon, 25 Sep 2017 22:45:19 GMT Anonymous 2017-09-25T22:45:19Z Conditional https://community.qlik.com/t5/QlikView/Conditional/m-p/1412028#M812008 <HTML><HEAD></HEAD><BODY><P>Please see attached example. I'm able to create two columns based on selected values, but I'm unable to create the correct conditional sum.... Please advise...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Conditional/m-p/1412028#M812008 Anonymous 2020-11-25T16:16:04Z Re: Conditional https://community.qlik.com/t5/QlikView/Conditional/m-p/1412029#M812011 <HTML><HEAD></HEAD><BODY><P>Not quite sure what you are looking for - a pivot table?</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#ffffff"><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Article</STRONG></SPAN><STRONG> </STRONG></TH><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Origen</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Forecast 2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Forecast 3</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1508</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1488</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">750</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">82</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">98</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">48</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">39</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5</SPAN></TD><TD bgcolor="#ffffff"> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">574</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6</SPAN></TD><TD bgcolor="#ffffff"> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">874</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 25 Sep 2017 22:16:54 GMT https://community.qlik.com/t5/QlikView/Conditional/m-p/1412029#M812011 swuehl 2017-09-25T22:16:54Z Re: Conditional https://community.qlik.com/t5/QlikView/Conditional/m-p/1412030#M812013 <HTML><HEAD></HEAD><BODY><P>Not exactly, as I need to add more dimensions... i.e. customers... It's just about the formula of the amounts:</P><P></P><P>I used Sum ({&lt;Origen = subfield(GetFieldSelections(Origen,'||'),'||',1)&gt;}[Amount]) but it's gives an error.</P><P></P><P><SPAN style="font-size: 13.3333px;">subfield(GetFieldSelections(Origen,'||'),'||',1) gives the first selected origen, but I'm not able to get the conditional sum correct using this value...</SPAN></P></BODY></HTML> Mon, 25 Sep 2017 22:45:19 GMT https://community.qlik.com/t5/QlikView/Conditional/m-p/1412030#M812013 Anonymous 2017-09-25T22:45:19Z Re: Conditional https://community.qlik.com/t5/QlikView/Conditional/m-p/1412031#M812014 <HTML><HEAD></HEAD><BODY><P>Got it! <SPAN style="font-size: 10pt;">It's:</SPAN></P><P></P><P>Sum ({&lt;Origen = {"$(=subfield(GetFieldSelections(Origen,'||'),'||',1))"}&gt;}[Amount])</P><P></P><P>Thanks Stefan!</P></BODY></HTML> Mon, 25 Sep 2017 23:04:22 GMT https://community.qlik.com/t5/QlikView/Conditional/m-p/1412031#M812014 Anonymous 2017-09-25T23:04:22Z