topic Compare a columns according to filter selection in QlikView https://community.qlik.com/t5/QlikView/Compare-a-columns-according-to-filter-selection/m-p/1403468#M612821 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />,</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I would like to select the different items of 2 sellers in order to compare them</SPAN></P><P>I have only one table with the item columns, and sellers</P><P>I created a pivot table but as output I have item of sellers grouped together.</P><P></P><P>thank you for your help</P></BODY></HTML> Thu, 05 Oct 2017 15:03:45 GMT 2017-10-05T15:03:45Z Compare a columns according to filter selection https://community.qlik.com/t5/QlikView/Compare-a-columns-according-to-filter-selection/m-p/1403468#M612821 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />,</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I would like to select the different items of 2 sellers in order to compare them</SPAN></P><P>I have only one table with the item columns, and sellers</P><P>I created a pivot table but as output I have item of sellers grouped together.</P><P></P><P>thank you for your help</P></BODY></HTML> Thu, 05 Oct 2017 15:03:45 GMT https://community.qlik.com/t5/QlikView/Compare-a-columns-according-to-filter-selection/m-p/1403468#M612821 2017-10-05T15:03:45Z Re: Compare a columns according to filter selection https://community.qlik.com/t5/QlikView/Compare-a-columns-according-to-filter-selection/m-p/1403469#M612822 <HTML><HEAD></HEAD><BODY><P>May be describe more..</P><P></P><P>I would think about simple above() and below() </P></BODY></HTML> Thu, 05 Oct 2017 15:53:09 GMT https://community.qlik.com/t5/QlikView/Compare-a-columns-according-to-filter-selection/m-p/1403469#M612822 Anil_Babu_Samineni 2017-10-05T15:53:09Z Re: Compare a columns according to filter selection https://community.qlik.com/t5/QlikView/Compare-a-columns-according-to-filter-selection/m-p/1403470#M612823 <HTML><HEAD></HEAD><BODY><P>To select two selection of a field you should go for alternate states. </P><P>What ever expression you are writing, write one for default state and another for alternate states and compare them </P><P></P><P>Best </P><P>Pradosh </P></BODY></HTML> Fri, 06 Oct 2017 18:57:26 GMT https://community.qlik.com/t5/QlikView/Compare-a-columns-according-to-filter-selection/m-p/1403470#M612823 pradosh_thakur 2017-10-06T18:57:26Z