Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eaphymaoweave
New Contributor II

Set Analysis for Table Totals?

I have a table which contains multiple weeks of data. Is there a way I can have the totals show the inventory for just a single week of interest (the current week, the earliest week, something like that)?

The sample table below would have something like 3 weeks of data, but I only want the total to show 1 week's figures. Is this even possible?

 

StoreInventory
150
220
310
Total80
1 Reply

Re: Set Analysis for Table Totals?

Hi Eaphy, Dimensionality() returns the number of dimensions in the actual row, so you can use this to set a different expression:

If(Dimensionality()=0, Sum({<Week={$(=Max (Week))}>} Inventory) //Total Row; Set analysis is only an example

, Sum(Inventory)) // Other rows

Community Browser