topic Data set analysis in QlikView

Data set analysis

Thu, 01 Oct 2009 16:27:58 GMT

Hi all,

i've got this statement:


Sum (
 {1<
 Calendar.Week={$(=Max(Calendar.Week))}
 >}
 NetSales
)

But now i want to also include the CalDate:

The result has to be the sum of NetSales for the max week but smaller or equal than the day selected

So I thought is was something like this:



Sum (
 {1<
 Calendar.Week={$(=Max(Calendar.Week))},

 Calendar.CalDate={$(<=(Calendar.CalDate))}
 >}
 NetSales
)

But this aint working correct.
Can anybody help me?

Tnx in advance

Reyman

Data set analysis

Thu, 01 Oct 2009 20:47:06 GMT

Give this a try:

Sum({1<Calendar.Week={$(=Max(Calendar.Week))},Calendar.CalDate={'<=$(=Calendar.CalDate)'}>} NetSales)

I pulled the less than or equal out of the dollar-sign expansion and put the whole Set Modifier in quotes.

The easiest way to test Set Analysis is to put your expression into a chart, but don't give it a label. On the chart, the label for that expression will be the Set Analysis expression with the dollar-sign expansion evaluated.