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: 
anmartin
Contributor II
Contributor II

Limit graph data in function of date filter selection

Hello,

I have a graph that is plotting data from a aggregation I have defined.

Currently the graphe shows all the data available in the source, no matter what the selections are.

However, I would like the data of the graph the be related to the week & year selected above, so that if the user choses weeknumber 3 and year 2020, the graph would show all the data UNTIL week number 3 of 2020, and not the data after.

What do I need to change in my formula to take the week & year concatenation in my selection ?

Attached is how my graph looks like currently and below is my data formula :

sum({<[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>}
aggr(
((sum({<[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>}[#Fournis] + [#Reassorts] - [#Invendus])
+
sum({<[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>} [#SubscriptionAlternateKeyOrderQuantity]))
)
,[DimProduct.ProductKey],Label_Flag_Gratuit,Mapping_Type,DiffusionType,[DimProduct.IsDigital],ConditionsAbosMod,ProductCategory,[DimGeography.CountryOrigin],[DimDate.WeekNumberOfYear],[DimDate.PublicationYear],PublicationDateKey
)
)/count({<[DimDate.IsDayOffBelgium] -= {1},[DimDate.WeekNumberOfYear]=,[DimDate.PublicationYear]=>}Distinct PublicationDateKey)

 

 

2 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

please go through the link attached 

https://community.qlik.com/t5/QlikView-Documents/YTQ-QTD-MTD-and-WTD/ta-p/1489245

Hope it helps 

thanks

Thanks and Regards
Kashyap.R
anmartin
Contributor II
Contributor II
Author

Thank you for the link but unfortunately it doesn't resolve my problem because I don"t want Year/Month/Week-to date but rather Start of the data to date.

I have data from 2018 in my set thus I would like to shaw data from the very start until this date that is for example he 20th of Febrary 2020.