Need help in Set analsysis

Tue, 25 Jun 2013 13:16:01 GMT

Hello Friends,

The requirement is really very funny because of the duplication of data.

what I want is today is 25/06/2013(Tuesday), I would like to display the previous week data only that is 18/06/2013,

I tried with a expression =Num(Count({<WEEK={"$(=max({<YEAR={"$(=max(YEAR))"}>}WEEK-1))"}>}NBINVOICES),'# ##0'), it counts the duplicate data of all the week data. I don't know how to add the unique DATE part in the expression.

Could you please some one help me....

YEAR	WEEK	DATE	NBINVOICES	VALUE	INVOICE NUMBER
2013	24	13/06/2013	1	1271,24	7027074
2013	24	14/06/2013	1	1271,24	7027074
2013	24	17/06/2013	1	1271,24	7027074
2013	24	18/06/2013	1	1271,24	7027074
2013	24	19/06/2013	1	1271,24	7027074
2013	25	20/06/2013	1	1271,24	7027074
2013	25	21/06/2013	1	1271,24	7027074
2013	25	24/06/2013	1	1271,24	7027074
2013	25	25/06/2013	1	1271,24	7027074

Regards

Chriss

topic Need help in Set analsysis in QlikView

Need help in Set analsysis