topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

Mon, 19 May 2014 09:19:38 GMT

Hi all I have data as attached below and need a table to display the sum sales where date is max

I used the below expression to do the same

sum({$<DATE={"$(=max(DATE))"}>}Sales)

I get the O/P as below

Now if I want all the customer’s name and their sales data with respective of their respective max(date)

As below

Kindly help

Thanking You

Vinayagam

kiranmanoharrode — Mon, 19 May 2014 09:31:09 GMT

Dear Vinayagam,

Please use AGGR function,

=Sum(AGGR(sum({$<DATE={"$(=max(DATE))"}>}Sales),[Customer Name],Month, Year, Date))

This will work.

Regards

Kiran Rode

+91 8976977897

Mon, 19 May 2014 09:41:57 GMT

hey Kiran

i tried the same but couldnt get the desired output

Thanking You

Vinayagam

anbu1984 — Mon, 19 May 2014 09:46:01 GMT

Try aggr only with Date field

=Sum(AGGR(sum({$<DATE={"$(=max(DATE))"}>}Sales),[Customer Name],Date))

tresB — Mon, 19 May 2014 09:52:21 GMT

Set analysis doesn't get executed row-wise. Try like in attached sample.