topic Alternate State and Set analysis conundrum in QlikView https://community.qlik.com/t5/QlikView/Alternate-State-and-Set-analysis-conundrum/m-p/706159#M254524 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am new to QlikView and just trying to get my head around alternate states and set analysis. I have several fields in my data:</P><P></P><P>Country</P><P>Region</P><P>Product_Type</P><P></P><P>Year</P><P>Month</P><P></P><P>I have a single sheet with the first three in list boxes in an alternate state called 'Datatables'.</P><P>I have a single straight table also in the 'Datatable' Alternate state.</P><P>'Month' and 'Year' have two listboxes each, the first in a alternate state called 'Comparison1' , the other in a state called 'Comparison2'.</P><P></P><P>The table has two columns, which sum a datafield called 'SalesValue' I would like both columns to honour selections made in the Country, Region and Product_type fields, whilst the first column reflects 'Year' &amp; 'Month' selections from listboxes in the 'Comparison1' state and the second column to reflect selections in the Year/Month in the Comparison2 state. Could someone help to point out the expression needed for this, as have tried a few attempts and its not working, is it even possible?</P><P>Would very much appreciate any help! thanks!!</P></BODY></HTML> Sat, 11 Oct 2014 09:53:20 GMT 2014-10-11T09:53:20Z Alternate State and Set analysis conundrum https://community.qlik.com/t5/QlikView/Alternate-State-and-Set-analysis-conundrum/m-p/706159#M254524 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am new to QlikView and just trying to get my head around alternate states and set analysis. I have several fields in my data:</P><P></P><P>Country</P><P>Region</P><P>Product_Type</P><P></P><P>Year</P><P>Month</P><P></P><P>I have a single sheet with the first three in list boxes in an alternate state called 'Datatables'.</P><P>I have a single straight table also in the 'Datatable' Alternate state.</P><P>'Month' and 'Year' have two listboxes each, the first in a alternate state called 'Comparison1' , the other in a state called 'Comparison2'.</P><P></P><P>The table has two columns, which sum a datafield called 'SalesValue' I would like both columns to honour selections made in the Country, Region and Product_type fields, whilst the first column reflects 'Year' &amp; 'Month' selections from listboxes in the 'Comparison1' state and the second column to reflect selections in the Year/Month in the Comparison2 state. Could someone help to point out the expression needed for this, as have tried a few attempts and its not working, is it even possible?</P><P>Would very much appreciate any help! thanks!!</P></BODY></HTML> Sat, 11 Oct 2014 09:53:20 GMT https://community.qlik.com/t5/QlikView/Alternate-State-and-Set-analysis-conundrum/m-p/706159#M254524 2014-10-11T09:53:20Z Re: Alternate State and Set analysis conundrum https://community.qlik.com/t5/QlikView/Alternate-State-and-Set-analysis-conundrum/m-p/706160#M254525 <HTML><HEAD></HEAD><BODY><P>Please post a sample app</P></BODY></HTML> Sat, 11 Oct 2014 10:34:40 GMT https://community.qlik.com/t5/QlikView/Alternate-State-and-Set-analysis-conundrum/m-p/706160#M254525 giakoum 2014-10-11T10:34:40Z