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