Plain table that you can program/hard code each cell

[Anonymous]

is there a plain table object in qlik sense that i can program or hard code each cell value rather than using the dimension, column and measures etc?

for example a table like this:

hard-coded header	hard-coded header
hard coded row name: "total value"	select sum(value) from table1
hard coded row name: "value change"	select sum(value) - sum(value_base) from table1
hard coded row name:  "percentage value change"	select (sum(value) - sum(value_base))/sum(value_base) from table1

table1 is a sql table.

thanks

[petter]

It is pretty straightforward to achieve this if you can live with doing the hardcoding in your load script. Then you can have multiple SQL statements each returning two values in a single row and adding these rows to a single table by doing CONCATENATE.

T1:
SQL             select 'total value' as T1h,sum(value) as T1m from table1;
concatenate SQL select 'value change' as T1h, sum(value) - sum(value_base) AS T1m from table1;
concatenate SQL select 'percentage value change' as T1h, select (sum(value) - sum(value_base))/sum(value_base) from table1 AS T1m from table1;

In a sheet you can create a regular Qlik Sense Table object and add T1h as dimension and T1m as a measure.

[Anonymous]

Thank you Petter.