Use expression from INLINE table?

skoppe — Fri, 12 Jul 2013 13:20:57 GMT

Hi all,

Is it possible to use expressions stored in INLINE tables?

I want to make a straight table with fixed rows, an index (for sorting), a name and 3 KPI's with their uom's.

This is the code I use to create the INLINE table:

LOAD

* INLINE "
EO_INDEX, EO_NAME, EO_KPI1, EO_KPI1_UNIT, EO_KP2, EO_KPI2_UNIT, EO_KPI3, EO_KPI3_UNIT
1, Dispatch, =sum(Dispatch), MW, =sum([APX price]), €/MWhe, =sum([E revenue]), €/hour
";

This is what I get in the fields/table.

EO_INDEX	EO_NAME	EO_KPI1	EO_KPI1_UNIT	EO_KP2	EO_KPI2_UNIT	EO_KPI3	EO_KPI3_UNIT
1	Dispatch	=sum(Dispatch)	MW	=sum([APX price])	€/MWhe	=sum([E revenue])	€/hour

When I try to use for instance field EO_KPI1 in a chart (straight table) then I only see the text like this:

EO_KPI1

=sum(Dispatch)

I tried different expression in the straight tablee, like: =EO_KPI1, EO_KPI1, ONLY(EO_KPI1)

I would like to have the value of sum(Dispatch) displayed.

Is this possible, am I close? I hope someone can help me.

Thanks in advance!

Regards,

Stefan

Re: Use expression from INLINE table?

marcus_sommer — Fri, 12 Jul 2013 13:23:23 GMT

See as an example http://community.qlik.com/message/289129#289129

- Marcus

Re: Use expression from INLINE table?

skoppe — Fri, 12 Jul 2013 13:47:06 GMT

thanks a lot!

topic Use expression from INLINE table? in QlikView

Use expression from INLINE table?

Re: Use expression from INLINE table?

Re: Use expression from INLINE table?