topic Re: Set Analysis help in QlikView

Set Analysis help

qlikmpate0 — Mon, 02 Jun 2014 10:44:43 GMT

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

Re: Set Analysis help

Mon, 02 Jun 2014 10:47:49 GMT

try:

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

Re: Set Analysis help

tresB — Mon, 02 Jun 2014 10:49:17 GMT

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

Re: Set Analysis help

qlikmpate0 — Mon, 02 Jun 2014 10:57:53 GMT

Still zero shipped qty

Re: Set Analysis help

qlikmpate0 — Mon, 02 Jun 2014 10:59:56 GMT

current period is like the period name? APR-14

Re: Set Analysis help

Mon, 02 Jun 2014 11:03:23 GMT

Mina

maybe you may attache example?

regards

Re: Set Analysis help

tresB — Mon, 02 Jun 2014 11:04:03 GMT

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]

Re: Set Analysis help

Mon, 02 Jun 2014 11:18:52 GMT

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