Set Analysis help

[qlikmpate0]

I'm trying to use set analysis to find the shipped qty sold within a time frame(ie Current period) I have the following statement, but I'm not getting any results. Can any one help? :-

({<[Current Period] = {'>=$(=Date([Calendar.START_DATE]))<=$(=Date(Calendar.END_DATE]))'} >} SHIPPED_QTY)

My inline table looks something like this, I have loaded the data to include the month and week no the data falls in

[#2]

try:

sum({<[Current Period] = {">=$(=Date([Calendar.START_DATE]))<=$(=Date(Calendar.END_DATE]))"} >} SHIPPED_QTY)

[tresesco]

I guess [Current Period] and other dates field data formats are not matching. How do they look like?

[qlikmpate0]

Still zero shipped qty

[qlikmpate0]

current period is like the period name? APR-14

[#6]

Mina

maybe you may attache example?

regards

D

[tresesco]

That is why it doesn't work. Probably, this field has been created in the script as string. Create the same field using MonthName() in the script like:

Load

          MonthName(DateField) as [Current Period]

[#8]

Hi,

I think your [Current Period] - date format not matching with

[Calendar.START_DATE] &

[Calendar.END_DATE]

that's why it's showing zero. otherwise syntax looks ok.

Vinay