Limit graph data in function of date filter selection

anmartin — Thu, 06 Feb 2020 08:56:51 GMT

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)

Re: Limit graph data in function of date filter selection

Kashyap_R — Mon, 17 Feb 2020 06:46:14 GMT

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

Re: Limit graph data in function of date filter selection

anmartin — Thu, 20 Feb 2020 08:20:33 GMT

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.

topic Limit graph data in function of date filter selection in App Development

Limit graph data in function of date filter selection

Re: Limit graph data in function of date filter selection

Re: Limit graph data in function of date filter selection