Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 "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
See as an example http://community.qlik.com/message/289129#289129
- Marcus
thanks a lot!