topic Re: Last month period date in QlikView

Last month period date

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

‌hey all,

if i need to calculate the sum of amount of the maximum periode on last month how can i write it in the set analysis?

hope you can help

thanks

Re: Last month period date

sunny_talwar — Fri, 18 Mar 2016 14:21:50 GMT

May be this:

{<Date = {"$(=Date(Floor(MonthEnd(Today(), -1)), 'YourDateFieldFormat'))"}>}

Re: Last month period date

mario-sarkis — Fri, 18 Mar 2016 14:38:20 GMT

‌my format field is num should i use the same expression ?

Re: Last month period date

sunny_talwar — Fri, 18 Mar 2016 14:40:10 GMT

Something along these lines:

{<Date = {"$(=Floor(MonthEnd(Today(), -1)))"}>}

Re: Last month period date

mario-sarkis — Fri, 18 Mar 2016 14:42:13 GMT

‌sorry sunny to disturb u but the pervious month sometimes doesnt have all days i just need The maximum period date in last month and my field is number type

Re: Last month period date

sunny_talwar — Fri, 18 Mar 2016 14:53:18 GMT

Do you have a sample you can share?

Re: Last month period date

mario-sarkis — Fri, 18 Mar 2016 15:04:02 GMT

‌unfortuantly i cant share my data online but as an example

lets say we are in march i need to calculate the sum of a balance in feb of list of ids but this balance is a snap shut balance. in my database i don't have all days cause the balance is saved one per week.

my request is the calculate this balance in the maximum periodedate in feb (it could be any day in feb)

hope this explanation can help