Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cyrilleleja
Contributor
Contributor

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

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

 

 

6 Replies
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?

talk is cheap, supply exceeds demand
cyrilleleja
Contributor
Contributor
Author

Hi

 

this is more details in the attached file : 

cyrilleleja
Contributor
Contributor
Author

Hi Gysbert, 

 Do you have all informations ? 

regards, 

 

Cyrille

 

cyrilleleja
Contributor
Contributor
Author

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.

talk is cheap, supply exceeds demand
cyrilleleja
Contributor
Contributor
Author

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])