Count in dimension in order to have data from w-1, w-2, w-3 ...

[cyrilleleja]

Dear community, 

I would like to count rows in a table in order to retrieve data from w-1, w-2, W-3 :

i tried this  : 

=AGGR(Above(if([date_created.autoCalendar.Week]=Week(Now(2)-1),count((date_created)))),[FID_shop_id-Offre - Identifiant unique])

to retrieve row from W46 (actually we are in 47) but it doesn't works ...

The goal is to count rows who have been created (date_created) in W-46, W-45 and W44 in order to see the evolution,

thanks for your help !!

[Gysbert_Wassenaar]

I'm afraid I don't understand what you're trying to do. Can you post a small Qlikview or QlikSense document that explains the problem?

[cyrilleleja]

Hi Gysbert_Wassenaar, 

this is more details in the attached file : 

[cyrilleleja]

Hi Gysbert, 

 Do you have all informations ? 

regards, 

Cyrille

[cyrilleleja]

Hello,

does anyone can help me ?

regards, 

Cyrille

[Gysbert_Wassenaar]

Sorry, don't understand at all what you're trying to do and what's not working.

[cyrilleleja]

I would like to count the numbers of rows created with week in parameters : 

=AGGR(count(([date_created.autoCalendar.Week]=Week(Now))),[FID_shop_id-Offre - Identifiant unique])