Set Analysis

nicolett_yuri — Tue, 09 Apr 2013 19:53:13 GMT

I have a table with MONTH, WEEK, DAY, PRODUCT and VALUE

I created a graph with dimension MONTH and PRODUCT, I need the VALUE of the biggest day of the month. (This value will be used to perform other account)

Problems encountered: When do the set analysis to catch the biggest day of the month, he does not respect the month dimension. Only respect when I select one month.

Expression used: SUM({$<DATA = {$(=max(DATA))} >} VALOR)

I've tried to use AGGR, FIRSTSORTEDVALUE, but had no success.

Follow the example application.

Thank you!

Re: Set Analysis

nicolett_yuri — Tue, 09 Apr 2013 23:45:09 GMT

I solved the problem without using Set Analysis:

Sum( If( DATA = Aggr( Nodistinct Max( DATA ), MES, PRODUTO ), VALOR ) )

But if someone solve otherwise post here!

topic Set Analysis in QlikView

Set Analysis

Re: Set Analysis