SUMIFS EQUIVALENT IN STRAIGHT TABLE

[NewToAllThis]

Hi,

New to Qlik Sense and having problem obtaining the sum in specified column (Qtty By YM) in straight table.

Tried formulas like sum({<Year=, Month=>})Qtty but without success.

I am also attaching the Excel file with SUMIFS formulas.

Any help will be much appreciated.

[Rodj]

You should be able to solve this with the Aggr() function. It appears that essentially you are trying to aggregate the DAY grained measure up to your YM level.

It  would be something like: Aggr(Sum(Qtty), YM)

Sorry I don't have access to download your file and test it out in your context but hopefully I've put you on the right track.