Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

How to Sum TotalWorkingHours for current and previous month

Hello Qlikrs

I want to calculate sum of 'Working Hours' for current and previous months.

I tried lots of set analysis but none of them are working.

Please find the attached sample qvf.

Here the data is till Mar-2018 so please calculate using Max function so that it should work for my live data too.

So please calculate Sum of working hours for Mar-2018 and Feb-2018