topic Expression columns in a simple table in QlikView

Expression columns in a simple table

Fri, 19 Aug 2011 14:06:39 GMT

Hello,

I need to make a simple table with a lot of expressions, so I need to make some columns,

ex:

actual table:

market_id

1 sales today 100

1 sales week to date 200

1 sales month to date 500

1 sales year to date 1400

desired table:

market_id

1 sales today 100 sales month to date 500

1 sales week to date 200 sales year to date 1400

I don't see any option to do it, is it possible???

Regards,

David

Expression columns in a simple table

its_anandrjs — Fri, 19 Aug 2011 14:22:41 GMT

Hi,

I dont understand your reqs as i understand you want to load two tables with same field names or want to represent as it is display right now in the table desired table. Do you have any sample if so please provide it.

Regards,

Anand

Expression columns in a simple table

Fri, 19 Aug 2011 14:35:36 GMT

Hi,

I need to represent several columns expressions it in the same table,

if I split the data in two different tables I'll have two scrolls and I don't want it...

Regards,

David

Expression columns in a simple table

Fri, 19 Aug 2011 15:21:47 GMT

Look into using a chart set to straight table or pivot table, which you may want to be "Always Expanded". A normal table does not support expressions.

Expression columns in a simple table

its_anandrjs — Fri, 19 Aug 2011 15:29:01 GMT

Hi,

As you say you want to display several columns expressions in the same table in this case one of the things you use try to create expressions in Variables or use in in the Straight Table or Pivot Table. and you use multiple expression there as a column expression.

Regards,

Anand

Expression columns in a simple table

Fri, 26 Aug 2011 09:47:05 GMT

Hi,

I have done with valuelist(actual,ly,ytd) as a dimension

and in the expression something like this:

if (valuelist(actual,ly,ytd))=actual,'' actual_expression1",

if (valuelist(actual,ly,ytd))=ly,"ly_expression2",

if (valuelist(actual,ly,ytd))=ytd,"ytd_expressionn")))

Thanks for your help,

David

Expression columns in a simple table

Wed, 14 Sep 2011 08:09:47 GMT

Hi,

Was about to ask virtually the same question! Many thanks for the info!!

Cheers,

Emma