If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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 !!
this is more details in the attached file :
Do you have all informations ?
does anyone can help me ?
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])