Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Data set analysis

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Data set analysis

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.

1 Reply
Not applicable

Data set analysis

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.

Community Browser