topic combined selections in straight table in QlikView https://community.qlik.com/t5/QlikView/combined-selections-in-straight-table/m-p/766069#M536656 <HTML><HEAD></HEAD><BODY><P>Hi to Everybody,</P><P></P><P>I'm working with QlikView vers. 9. I can't upgrade to 11.<BR /><SPAN class="short_text" lang="en"><SPAN class="hps">I</SPAN> <SPAN class="hps">need to</SPAN> <SPAN class="hps">make a selection on a straight table. <SPAN class="hps">I want to consider</SPAN> <SPAN class="hps">only the rows</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">a value of -1</SPAN> <SPAN class="hps">expression</SPAN> <STRONG>Semaforo.</STRONG> <SPAN class="short_text" lang="en"><SPAN class="hps">See</SPAN> <SPAN class="hps">attached</SPAN> <SPAN class="hps"><STRONG>Esempio.qvw</STRONG>. <SPAN lang="en"><SPAN class="hps">The graph</SPAN> <SPAN class="hps">consists of two</SPAN> <SPAN class="hps">dimensions</SPAN><SPAN>,</SPAN> <SPAN class="hps">each of which is</SPAN> <SPAN class="hps">a cyclic group.</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">It is</SPAN> <SPAN class="hps">to select combinations</SPAN> <SPAN class="hps">defined by a</SPAN> <SPAN class="hps">value of the</SPAN> <SPAN class="hps">first</SPAN> <SPAN class="hps">dimension</SPAN> <SPAN class="hps">AND</SPAN> a <SPAN class="hps">value</SPAN> <SPAN class="hps">of the</SPAN> <SPAN class="hps">second</SPAN> <SPAN class="hps">dimension.</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">By making a</SPAN> <SPAN class="hps">selection</SPAN> <SPAN class="hps">(see</SPAN> <SPAN class="hps"><STRONG>selezione.JPG</STRONG></SPAN><SPAN>)</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">result is not as</SPAN> <SPAN class="hps">expected</SPAN> <SPAN class="hps">(see</SPAN> <SPAN class="hps"><STRONG>risultato_selezione.JPG</STRONG></SPAN><SPAN>)</SPAN><SPAN>, although it is</SPAN> <SPAN class="hps">consistent with the logic</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">QlikView</SPAN><SPAN>.</SPAN> </SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN style="text-decoration: underline;">I don't want</SPAN> define in script a new field <SPAN lang="en"><SPAN class="hps">for each combination</SPAN> <SPAN class="hps">of the fields</SPAN> <SPAN class="hps">of the two</SPAN> <SPAN class="hps">cyclic groups </SPAN></SPAN>and use <SPAN class="short_text" lang="en"><SPAN class="hps">the</SPAN> <SPAN class="hps">appropriate</SPAN> <SPAN class="hps">field as a dimension.</SPAN></SPAN> <SPAN class="short_text" lang="en"><SPAN class="hps">I have too many</SPAN> <SPAN class="hps">combinations to manage</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="short_text" lang="en"><SPAN class="hps"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">Any idea on</SPAN> <SPAN class="hps">how to solve</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">issue</SPAN><SPAN>?</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN> </P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN>Thank you in advance</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN>Regards</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 18 Nov 2014 08:57:45 GMT stefano_marson 2014-11-18T08:57:45Z combined selections in straight table https://community.qlik.com/t5/QlikView/combined-selections-in-straight-table/m-p/766069#M536656 <HTML><HEAD></HEAD><BODY><P>Hi to Everybody,</P><P></P><P>I'm working with QlikView vers. 9. I can't upgrade to 11.<BR /><SPAN class="short_text" lang="en"><SPAN class="hps">I</SPAN> <SPAN class="hps">need to</SPAN> <SPAN class="hps">make a selection on a straight table. <SPAN class="hps">I want to consider</SPAN> <SPAN class="hps">only the rows</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">a value of -1</SPAN> <SPAN class="hps">expression</SPAN> <STRONG>Semaforo.</STRONG> <SPAN class="short_text" lang="en"><SPAN class="hps">See</SPAN> <SPAN class="hps">attached</SPAN> <SPAN class="hps"><STRONG>Esempio.qvw</STRONG>. <SPAN lang="en"><SPAN class="hps">The graph</SPAN> <SPAN class="hps">consists of two</SPAN> <SPAN class="hps">dimensions</SPAN><SPAN>,</SPAN> <SPAN class="hps">each of which is</SPAN> <SPAN class="hps">a cyclic group.</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">It is</SPAN> <SPAN class="hps">to select combinations</SPAN> <SPAN class="hps">defined by a</SPAN> <SPAN class="hps">value of the</SPAN> <SPAN class="hps">first</SPAN> <SPAN class="hps">dimension</SPAN> <SPAN class="hps">AND</SPAN> a <SPAN class="hps">value</SPAN> <SPAN class="hps">of the</SPAN> <SPAN class="hps">second</SPAN> <SPAN class="hps">dimension.</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">By making a</SPAN> <SPAN class="hps">selection</SPAN> <SPAN class="hps">(see</SPAN> <SPAN class="hps"><STRONG>selezione.JPG</STRONG></SPAN><SPAN>)</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">result is not as</SPAN> <SPAN class="hps">expected</SPAN> <SPAN class="hps">(see</SPAN> <SPAN class="hps"><STRONG>risultato_selezione.JPG</STRONG></SPAN><SPAN>)</SPAN><SPAN>, although it is</SPAN> <SPAN class="hps">consistent with the logic</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">QlikView</SPAN><SPAN>.</SPAN> </SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN style="text-decoration: underline;">I don't want</SPAN> define in script a new field <SPAN lang="en"><SPAN class="hps">for each combination</SPAN> <SPAN class="hps">of the fields</SPAN> <SPAN class="hps">of the two</SPAN> <SPAN class="hps">cyclic groups </SPAN></SPAN>and use <SPAN class="short_text" lang="en"><SPAN class="hps">the</SPAN> <SPAN class="hps">appropriate</SPAN> <SPAN class="hps">field as a dimension.</SPAN></SPAN> <SPAN class="short_text" lang="en"><SPAN class="hps">I have too many</SPAN> <SPAN class="hps">combinations to manage</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="short_text" lang="en"><SPAN class="hps"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">Any idea on</SPAN> <SPAN class="hps">how to solve</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">issue</SPAN><SPAN>?</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN> </P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN>Thank you in advance</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN>Regards</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 18 Nov 2014 08:57:45 GMT https://community.qlik.com/t5/QlikView/combined-selections-in-straight-table/m-p/766069#M536656 stefano_marson 2014-11-18T08:57:45Z Re: combined selections in straight table https://community.qlik.com/t5/QlikView/combined-selections-in-straight-table/m-p/766070#M536657 <HTML><HEAD></HEAD><BODY><P>What you want is not possible afaik. The only way to do this is to create a new field in the script or to hard-code the selections in a set analysis expression.</P></BODY></HTML> Tue, 18 Nov 2014 09:17:58 GMT https://community.qlik.com/t5/QlikView/combined-selections-in-straight-table/m-p/766070#M536657 Gysbert_Wassenaar 2014-11-18T09:17:58Z