topic Re: Set Anayls LY Period Problem in QlikView

Set Anayls LY Period Problem

lylererger — Sun, 15 Jun 2014 07:25:16 GMT

Hi.

Help me to understand why that formula is not woking:

=SUM({<Date={'>=$(=addyears(min({<[Operation ID]={1}>}Date),-1))<=$(=addyears(max(TOTAL{<[Operation ID]={1}>}Date),-1))'}>}[# Sales Amount])

Thnx.

Re: Set Anayls LY Period Problem

MK_QSL — Sun, 15 Jun 2014 07:56:36 GMT

What you want to achieve?

SUM({<Date = {">=$(=AddYears(Min(Date),-1))<=$(=AddYears(Max(Date),-1))"}, [Operation ID]={1}>}[# Sales Amount])

Re: Set Anayls LY Period Problem

lylererger — Sun, 15 Jun 2014 08:04:23 GMT

Sales for the previous period.

Your formula is not working!

Formula of sales for the current period
=SUM({<Date={'>=$(=min({<[Operation ID]={1}>}Date))<=$(=max(TOTAL{<[Operation ID]={1}>}Date))'}>}[# Sales Amount])

Operation ID = 1 it's dates of Sales. I've got the quota and budget's where Operation ID = 2 and 3.

I just need the sales for the previous period (Last Year)

But that formula isn't working (((
=SUM({<Date={'>=$(=addyears(min({<[Operation ID]={1}>}Date),-1))<=$(=addyears(max(TOTAL{<[Operation ID]={1}>}Date),-1))'}>}[# Sales Amount])

It's looks like so easy task. But i still have no any idea how to solve it.

Help...

Re: Set Anayls LY Period Problem

MK_QSL — Sun, 15 Jun 2014 08:15:47 GMT

Better if you can provide little data also. this could make our task of giving answer easy.

Re: Set Anayls LY Period Problem

lylererger — Sun, 15 Jun 2014 08:20:57 GMT

It's not possible. I'm working on the clients server and can't copy any data.
Private security policy.

May be any advice. Any errors in script?

Re: Set Anayls LY Period Problem

MK_QSL — Sun, 15 Jun 2014 08:28:07 GMT

You can obviously create a dummy data in excel file.

Keep only related fields of your requirements and of having same format.

We need only 15-20 rows with Date, Operation ID, Sales Amount and also using those data, kindly provide what is the output result you wants.

We should be very accurate while using Dates in Set Analysis. The comparison should be between same format.

Also, just want to know why you are using TOTAL Qualifier...

Re: Re: Set Anayls LY Period Problem

lylererger — Sun, 15 Jun 2014 08:52:54 GMT

Whether there can be it because I filled emptiness with text values? !

Re: Set Anayls LY Period Problem

MK_QSL — Sun, 15 Jun 2014 13:29:48 GMT

What output you expecting?