topic Re: date range selection in Qlik Learning Discussions

date range selection

sakamsureshbabu — Thu, 05 Feb 2015 04:22:18 GMT

HI All

i have one data filed name is "Posting Date"

i need one expression like sum(Qty),but i have one condition in this expression that is it must show total Qty from starting Date to selected date.i am created calender by using variables like vFromeDate and vToDate.

my condition is

sum({<"Posting Date"={'>=min("Posting Date")<=$(vToDate)'}>}Qty)

this is not worrying so plz help any one.

Re: date range selection

marcus_sommer — Thu, 05 Feb 2015 09:41:01 GMT

Try this:

sum({<[Posting Date]={">=$(=min([Posting Date]))<=$(vToDate)"}>}Qty)

Important is further that [Posting Date] has the same format like min([Posting Date]) and $(vToDate) what I assume is rather unlikely so that you need additionally formatings, like: date(min([Posting Date]), 'YourFormat')

- Marcus

Re: date range selection

sakamsureshbabu — Thu, 05 Feb 2015 10:08:12 GMT

Thanks Marcus

i will try