topic Variable in set analysis with aggregation in QlikView

Variable in set analysis with aggregation

Anonymous — Tue, 24 Oct 2017 13:17:54 GMT

Colleagues, good day!

In my dummy model i have two tables:

//Table with settings

Set:

LOAD Id,

EndDate

FROM

Test.xlsx

(ooxml, embedded labels, table is Settings);

//Table with sales

Sales:

LOAD Id,

Date,

Sales

FROM

Test.xlsx

(ooxml, embedded labels, table is Data);

In qvw i created variable vComp, which calculate the date week before based on EndDate.

is it possible to calculate in set analysis sum of sales for those Dates >=vComp. The idea - value of this variable should be aggregated by Id, because One Id could have several vComp values.

Thanks!

Re: Variable in set analysis with aggregation

sunny_talwar — Tue, 24 Oct 2017 13:26:44 GMT

So how would the find table look like? Would you be able to share expected output in an Excel file?

Re: Variable in set analysis with aggregation

Anonymous — Tue, 24 Oct 2017 13:37:02 GMT

See please new input file and output.
set analysis should calculate data only for yellow cells.

Thanks.