Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in Set analsysis

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....

 

YEARWEEKDATENBINVOICESVALUEINVOICE NUMBER
20132413/06/201311271,247027074
20132414/06/201311271,247027074
20132417/06/201311271,247027074
20132418/06/201311271,247027074
20132419/06/201311271,247027074
20132520/06/201311271,247027074
20132521/06/201311271,247027074
20132524/06/201311271,247027074
20132525/06/201311271,247027074

Regards

Chriss

Labels (1)
0 Replies