topic Set Analysis Question in QlikView

Set Analysis Question

Wed, 27 Aug 2014 18:29:50 GMT

Hi,

We have a set of records namely R1,R2 etc. Each of them has a Finish Date. Now we want to create a set analysis based on the Finish date to find sales in that month

Eg:

Sum({<Month={"$(=month(Finish Date)"}>}Sales)

This is causing issues as the values for each record should take the corresponding Finish date. But that's not happening now. How to code such that it dynamically chooses the values in that particular field?

Thanks.

Re: Set Analysis Question

nagaiank — Wed, 27 Aug 2014 18:46:59 GMT

Probably you need to create a calendar for Finished Date.

Tutorial - Using Common Date Dimensions and Shared Calendars

Re: Set Analysis Question

rwunderlich — Wed, 27 Aug 2014 18:53:59 GMT

What are you trying to achieve with the set analysis?

I would think a chart like you are describing would not need any set analysis.

1. Calculated Dimension: =month([Finish Date])

2. Expression: =sum(Sales)

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Set Analysis Question

Wed, 27 Aug 2014 20:37:45 GMT

we have many expressions which uses the finish date.

one expression is to find the first billing Date after the Finish date

min(Billing date> Finish date,Billing Date)

Also another expression to find sales between Finish date and Project end date where Project End date is static.

if we can code for individual value sin the field in the Set Analysis, it will help