topic Re: set analysis in straight table in QlikView https://community.qlik.com/t5/QlikView/set-analysis-in-straight-table/m-p/701517#M253218 <HTML><HEAD></HEAD><BODY><P>You need to put set analysis into the expression {&lt;state={'haryana'}&gt;}.</P><P>If you don't have any measures and you're want a straight table nevertheless, I recommend you to put state, id, name as dimensions and add year as an expression using the only() function, e.g. =Only({&lt;state={'haryana'}&gt;} year).</P><P>This should work.</P></BODY></HTML> Mon, 15 Sep 2014 17:00:21 GMT simondachstr 2014-09-15T17:00:21Z set analysis in straight table https://community.qlik.com/t5/QlikView/set-analysis-in-straight-table/m-p/701516#M253217 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P>I I want to incorporate conditional dimension in straight table,How to do so..</P><P>eg:</P><P>I have data like</P><P></P><P>state&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year</P><P>haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012</P><P>Gujrat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012</P><P>haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013</P><P>hp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014</P><P></P><P></P><P>I want to make straight table which is having dimensions as state,id and name for only haryana state. and I want to do this filteration in front end..</P><P></P><P></P><P>Thanks in anticipation</P></BODY></HTML> Mon, 15 Sep 2014 16:56:13 GMT https://community.qlik.com/t5/QlikView/set-analysis-in-straight-table/m-p/701516#M253217 neha_sri 2014-09-15T16:56:13Z Re: set analysis in straight table https://community.qlik.com/t5/QlikView/set-analysis-in-straight-table/m-p/701517#M253218 <HTML><HEAD></HEAD><BODY><P>You need to put set analysis into the expression {&lt;state={'haryana'}&gt;}.</P><P>If you don't have any measures and you're want a straight table nevertheless, I recommend you to put state, id, name as dimensions and add year as an expression using the only() function, e.g. =Only({&lt;state={'haryana'}&gt;} year).</P><P>This should work.</P></BODY></HTML> Mon, 15 Sep 2014 17:00:21 GMT https://community.qlik.com/t5/QlikView/set-analysis-in-straight-table/m-p/701517#M253218 simondachstr 2014-09-15T17:00:21Z