topic simple set analysis question in QlikView

simple set analysis question

amien — Mon, 02 Jan 2012 21:08:06 GMT

SUM({1<Year = {$(=MAX(Year))}, Month = {"<=$(=MAX({<Year ={$(=MAX(Year))}>} Month)"}>} Costs)

This gives me a nice YTD value, based on the maximum year and month selected (if any selected)

but now my customer list doesn't react anymore .. what do i need to change/add?

swuehl — Mon, 02 Jan 2012 21:18:07 GMT

Try either using a set identifier $ instead of 1 if you want to use the current selection set as base:

SUM({$<Year = {$(=MAX(Year))}, Month = {"<=$(=MAX({<Year ={$(=MAX(Year))}>} Month)"}>} Costs)

SUM({1<Year = {$(=MAX(Year))}, Month = {"<=$(=MAX({<Year ={$(=MAX(Year))}>} Month)"}, Customer = p() >} Costs)

to regard the current possible Customer values in your set.

Hope this helps,

Stefan

amien — Mon, 02 Jan 2012 21:22:49 GMT

hmm .. $ is ok .. BUT Month is this format : 1,2,3,4

But the user selects a different dimension : MonthName : jan, feb, mrt etc

it works when i make a selection based on Month (1,2,3) .. but not on MonthName. But i cann't calculate with Monthname?

amien — Mon, 02 Jan 2012 21:30:58 GMT

nevermind .. it's translated in the set analysis .. jan becomes 01

Thanks swuehl ..

where are you from btw? Remember me to buy to a drink if i ever meet you