topic Plain table that you can program/hard code each cell in App Development

Plain table that you can program/hard code each cell

Anonymous — Mon, 02 Jul 2018 21:15:30 GMT

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 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

Re: Plain table that you can program/hard code each cell

petter — Tue, 03 Jul 2018 07:10:04 GMT

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.

Re: Plain table that you can program/hard code each cell

Anonymous — Tue, 28 Aug 2018 20:57:11 GMT

Thank you Petter.