topic Re: Expression to return list of values in QlikView https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443718#M165435 <HTML><HEAD></HEAD><BODY><P>Then maybe using a straight table with a hidden dimension column and three expressions?</P></BODY></HTML> Sun, 17 Feb 2013 20:58:01 GMT swuehl 2013-02-17T20:58:01Z Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443713#M165430 <HTML><HEAD></HEAD><BODY><P>What's the best way to return a list of values (non-numeric) in an expression.</P><P></P><P>I have Projects and Project Status. I'd like to have Project Status as dimension and the Projects falling in various stages as the expression and then color code the background based on their delay status.</P><P></P><P>There is no calendar in the app. It is a point in time for daily status.</P></BODY></HTML> Sun, 17 Feb 2013 14:50:24 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443713#M165430 avastani 2013-02-17T14:50:24Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443714#M165431 <HTML><HEAD></HEAD><BODY><P>You may create a pivot table chart with Project Status and Project as dimensions and delay status as expression.</P></BODY></HTML> Sun, 17 Feb 2013 15:33:41 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443714#M165431 nagaiank 2013-02-17T15:33:41Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443715#M165432 <HTML><HEAD></HEAD><BODY><P>No can’t do. I tried that. The visible chart object should look like</P><P></P><P>Phase1 Phase2 Phase3</P><P>ProjectA ProjectB ProjectD</P><P>ProjectC ProjectX</P><P> ProjectZ</P><P></P><P></P><P>With color codes for each project cased on their delay status in each phase</P></BODY></HTML> Sun, 17 Feb 2013 16:02:55 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443715#M165432 avastani 2013-02-17T16:02:55Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443716#M165433 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P></BODY></HTML> Sun, 17 Feb 2013 17:45:36 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443716#M165433 swuehl 2013-02-17T17:45:36Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443717#M165434 <HTML><HEAD></HEAD><BODY><P>Yes, more so like attached but need to rid the Rowno() off the pivot though</P></BODY></HTML> Sun, 17 Feb 2013 19:54:23 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443717#M165434 avastani 2013-02-17T19:54:23Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443718#M165435 <HTML><HEAD></HEAD><BODY><P>Then maybe using a straight table with a hidden dimension column and three expressions?</P></BODY></HTML> Sun, 17 Feb 2013 20:58:01 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443718#M165435 swuehl 2013-02-17T20:58:01Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443719#M165436 <HTML><HEAD></HEAD><BODY><P>Yes, I had that as well, but the sad part is I have to encode every Phase in there and if there's new phases in the future, maintenance becomes a pain.</P><P></P><P>Pivot would have been ideal.</P><P></P><P>Interesting suggestion on how the autonumber(Project, Phase) brings it together. I know there's a way, just can't think of it right now. Brain freeze,</P></BODY></HTML> Sun, 17 Feb 2013 21:03:07 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443719#M165436 avastani 2013-02-17T21:03:07Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443720#M165437 <HTML><HEAD></HEAD><BODY><P>If you like the pivot but just want to hide the RowNo() column , how about just making the column invisible like the attached? (You can drag a column to about 1 pixel wide by dragging, I used a one-time macro to make it 0 pixels wide).</P><P></P><P>-Rob</P></BODY></HTML> Mon, 18 Feb 2013 00:11:52 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443720#M165437 rwunderlich 2013-02-18T00:11:52Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443721#M165438 <HTML><HEAD></HEAD><BODY><P>that does the trick. Man o man what a day. Thanks Rob</P></BODY></HTML> Mon, 18 Feb 2013 00:20:48 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443721#M165438 avastani 2013-02-18T00:20:48Z Re: Expression to return list of values https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443722#M165439 <HTML><HEAD></HEAD><BODY><P>Thanks to you swuehl for the rowno addition. </P></BODY></HTML> Mon, 18 Feb 2013 00:22:26 GMT https://community.qlik.com/t5/QlikView/Expression-to-return-list-of-values/m-p/443722#M165439 avastani 2013-02-18T00:22:26Z