Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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" |
|
table1 is a sql table.
thanks
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.
Thank you Petter.