Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

zions087244
New Contributor

Plain table that you can program/hard code each cell

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

2 Replies
MVP
MVP

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

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.



zions087244
New Contributor

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

Thank you Petter.