topic Set Analysis - Alternate States - Null Values in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Alternate-States-Null-Values/m-p/809924#M1043180 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>So I'm doing some comparative analysis using Alternate States. My issue is I have two different dimensions that I want to be able to make selections on that affect both states. So I've been using the following expressions: <SPAN style="font-size: 10pt; line-height: 1.5em;">MEDIAN({[AltState] &lt;Region= $::Region, Date = $::Date &gt; } Sales). The issue that I am running into now is only calculates the Sales median where Region and Sales is not null, however I would like it to look at all values of Region and Date when there is no selection made.</SPAN></P><P></P><P>Any help is greatly appreciated.</P><P></P><P>J</P></BODY></HTML> Mon, 24 Nov 2014 21:03:07 GMT 2014-11-24T21:03:07Z Set Analysis - Alternate States - Null Values https://community.qlik.com/t5/QlikView/Set-Analysis-Alternate-States-Null-Values/m-p/809924#M1043180 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>So I'm doing some comparative analysis using Alternate States. My issue is I have two different dimensions that I want to be able to make selections on that affect both states. So I've been using the following expressions: <SPAN style="font-size: 10pt; line-height: 1.5em;">MEDIAN({[AltState] &lt;Region= $::Region, Date = $::Date &gt; } Sales). The issue that I am running into now is only calculates the Sales median where Region and Sales is not null, however I would like it to look at all values of Region and Date when there is no selection made.</SPAN></P><P></P><P>Any help is greatly appreciated.</P><P></P><P>J</P></BODY></HTML> Mon, 24 Nov 2014 21:03:07 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Alternate-States-Null-Values/m-p/809924#M1043180 2014-11-24T21:03:07Z