topic Re: Straight table tasks in QlikView

Straight table tasks

nikhilgarg — Mon, 06 Apr 2015 08:01:10 GMT

Hi,

Whenever i add a new column in straight table , i want for newly added column:

Adjust Column width automatically

Add comma delimited.

How can i achieve this ??

Thanks

Re: Straight table tasks

jagan — Mon, 06 Apr 2015 08:16:03 GMT

Hi,

Can you come up with some sample data?

For dimension in Straight table the width of the table is automatically adjusted, for expression you will get a scroll bar, if you don't want the scroll bar then you have to adjust manually.

For comma separated values you have use Concat(DimensionName, ',') .

IF you want distinct values as comma separated then you can specify Distinct

Concat(Distinct DimensionName, ',')

Hope this helps you.

Regards,

jagan.

Re: Straight table tasks

nikhilgarg — Mon, 06 Apr 2015 08:20:11 GMT

Hey,

Can you please tell me what would be the output if i use:

Concat(DimensionName, ',')

Thanks

Re: Straight table tasks

jagan — Mon, 06 Apr 2015 08:28:46 GMT

Hi,

Concat() returns the values in given format, assume that you have 2012, 2013, 2014 and 2015 in Year list box, if you give

Concat(Year, ':') then you will get 2012:2013:2014:2015

Hope this helps you

Regards,

jagan.

Re: Straight table tasks

sibideepak — Mon, 06 Apr 2015 10:52:08 GMT

Hi,

Can you explain about your requirement clearly , with desired o/p ??