Date Range in Different Month

hamdaniahmad — Tue, 04 Aug 2015 03:11:49 GMT

Hello all,

I really hope that you could assist me with the following.

I have some trouble how to show date range and different month with same date. I use this formula :

sum({<Date_Fix={">=$(=MonthStart(AddMonths(max(Date_Fix),-1)))<=$(=AddMonths(max(Date_Fix),-1)) and >=$(=MonthStart(AddMonths(max(Date_Fix),0)))<=$(=AddMonths(max(Date_Fix),0))"}, [CATEGORY 2]={"*"}-{'CBU','DEL'}>}sales_qty)

For example, today is 4th Aug 2015, my expectation, the data will showing 1-4 Aug 2015 and 1-4 Juli 2015.

I will compare with same dimension = month

Please help me for this case, and I'm sorry for my bad english, Thank you

Re: Date Range in Different Month

antoniotiman — Tue, 04 Aug 2015 15:21:37 GMT

Try

Sum({<Date_Fix={">=.......<=........."}+{">= ............<=......."},[CATEGORY 2-={'CBU','DEL'}>} sales_qty)

Re: Date Range in Different Month

hamdaniahmad — Wed, 05 Aug 2015 04:01:14 GMT

Thank you Antonio, it is worked..!!

topic Date Range in Different Month in QlikView

Date Range in Different Month

Re: Date Range in Different Month

Re: Date Range in Different Month