topic Set analysis, inverse selection over dimensions in QlikView

Set analysis, inverse selection over dimensions

Sun, 19 Jun 2011 12:41:14 GMT

Hi,

I'm currently experimenting with set analysis. I have a Select Field year=1998. In a pivot table I'm showing sum( turnover ) over the EMPLOYEE_lastname and DATE_MONTH-nr fields. I tried showing the turnover for other years with the expression:

sum( {1-$} turnover )

Surprisingly, this adds a new row with a null value for EMPLOYEE_lastname. I believe wothout the TOTAL qualifier, this is supposed to work within the given dimensions though. Am I overlooking something here?

regards Jeroen

Set analysis, inverse selection over dimensions

erichshiino — Tue, 21 Jun 2011 16:45:22 GMT

I'm not sure if this can answer your question completely, but {1-$} will give you the set excluded by the selection (considering all the selecitons in the .QVW). If you want to get the exclusion only in a field, your set analysis would be more like:

sum( { <year= e(year)>} turnover )

Total will only make sense inside an object (or in a Aggr() function) because it will ignore the dimensions (not selections)

Hope this helps,

Erich