topic Re: Table - Multiple Calculations stacked in QlikView

Table - Multiple Calculations stacked

jono19872002 — Tue, 14 Sep 2021 11:14:23 GMT

I'm sure it is possible, but wanted to know how i can manipulate a table so show two calculations seperately within the same column

eg top half of table sum sales by the region dimension and then underneath a summarised row of total prior year (not split by dimension)

	April	May	June
UK	10	10	15
EU	15	10	20
USA	20	15	20
Total Sales	45	35	55

Prior Year	55	69	70

Re: Table - Multiple Calculations stacked

chrismarlow — Tue, 14 Sep 2021 18:50:56 GMT

Hi,

A way I've seen involves using a calculated dimension with a ValueList (depends on you region having a smallish fixed number of values) & then Pick/Match to write an expression for each row, so something like the below (but will be very dependent on your data model, so have cut a lot of corners here);

Cheers,

Chris.