topic Re: String in expression, one row for each string in QlikView

String in expression, one row for each string

Fri, 15 Jul 2016 07:53:09 GMT

Hi All,

I have to show String value in expression with one value for each row, I could have used Only function but since the String values are multiple for one dimension value, only is returning null, please help.

1. Cant use calculated dimension, as selection will result in multiple items in current selection box<Hide using _ prefix, but not recommended>

PFA the demo app.

Regards,

Navdeep

Re: String in expression, one row for each string

rubenmarin — Fri, 15 Jul 2016 08:00:32 GMT

Hi navdeep, you'll need a dimension that creates the rows so it will be easier keep your table with the 1's and hide this column (In presentation tab) and remove totals.

Another option is using a Table Box.

Re: String in expression, one row for each string

Fri, 15 Jul 2016 08:54:25 GMT

Hi Ruben,

Setup is in such a way that I cant use it in dimension and unfortunately straight table is again not an option, please suggest something else.

Regards,

Navdeep