topic Re: Set Analysis in QlikView

Set Analysis

Tue, 28 Jan 2014 14:17:42 GMT

Hello,

someone can help me?

I'd like to create a table like this:

PARTNBR	Week_26-29	Week_27-30	Week_28-31
504129021	109	135	152
504129605	312	327	371
504129606	633	651	659
504129607	931	967	992
504129609	247	261	268

related with the following selection:

where i.e. 109 is the total volume (Q_rich) of the partnbr between the week 26 and 29.

Which is the correct syntax of the expression "sum( {$<week = {(week)-2} >} Q_rich )" of the column week_26-29?

Thank you in advance

Re: Set Analysis

MK_QSL — Tue, 28 Jan 2014 14:40:07 GMT

What could be your selection to get this result?

Re: Set Analysis

Tue, 28 Jan 2014 14:49:09 GMT

I'd like to compare the result i get calculating the expression with the selection 28-31 (week) with the result I get with the selection 27-30 and 26-29, maintaining the selection

week

Re: Set Analysis

Anonymous — Tue, 28 Jan 2014 16:50:50 GMT

I think this works:

sum({<week={$(=concat(distinct week-2,','))} >} Q_rich)

Re: Set Analysis

Tue, 28 Jan 2014 17:29:42 GMT

Thank you very much! It works!