topic Between Dates Set analysis in QlikView

Between Dates Set analysis

siddheshmane — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm working on set analysis which requires between dates

-(sum({<[Posting Date]={"$(= '>=' & $(=DATE(TODAY() - 30)) & '<=' & $(=DATE(TODAY())))"}, [Document Type]={'Invoice'}>}Quantity))

But my output displays as 0.

Can someone help me with this.

Thanks,

Siddhesh Mane

avinashelite — Fri, 26 May 2017 07:10:43 GMT

Try like this

sum({<[Posting Date]={">=$(=DATE(TODAY() - 30)) <=$(=DATE(TODAY()))"}, [Document Type]={'Invoice'}>}Quantity))

sunny_talwar — Fri, 26 May 2017 09:37:34 GMT

Or this where you don't use the second dollar sign expansions for Date(Today()....) part:

-(Sum({<[Posting Date]={"$(= '>=' & Date(Today() - 30) & '<=' & Date(Today()))"}, [Document Type]={'Invoice'}>} Quantity))