topic Re: sum based on refernce date to today in QlikView

sum based on refernce date to today

Tue, 16 Feb 2016 07:09:08 GMT

I have a table which details number of hours worked by day/month/year I am looking to calculate total number of hours worked based (fixed date) held in separate table [LTA_Date]

What i am looking to do is sum of hours {'Hours without LTA'} from [LTA_Date] to today

Basically this will give me total number of hours worked from last LTA date

I have the basic hours calulation as below but am struggling to add the extra dimension

= num(sum({<[HType]={'Hours without LTA'}>}[NDA]+[LLWR]+[Sellafield]+[DRS]))

Any suggestions much appciated

Re: sum based on refernce date to today

sunny_talwar — Tue, 16 Feb 2016 10:10:48 GMT

Would it be possible to share a sample with your expected output?

Re: sum based on refernce date to today

Anonymous — Tue, 16 Feb 2016 10:20:53 GMT

try like this?

=sum(<[HType]={'Hours without LTA'},DateField={"$(= '>=' & date(LTA_Date_Value) & '<=' & date(Today))"}>} Sales)

Re: sum based on refernce date to today

Tue, 16 Feb 2016 13:16:20 GMT

=sum(<[HType]={'Hours without LTA'},[LTA_Date]={"$(= '>=' & date[LTA_Date] & '<=' & date(Today))"}>}[NDA]+[LLWR]+[Sellafield]+[DRS])

does not work table image below

Re: sum based on refernce date to today

Tue, 16 Feb 2016 13:42:14 GMT

I have shared below hope fully this will help with resolution