topic Re: Sheet subscription for previous day date filter only in Reporting Service & Alerting

Sheet subscription for previous day date filter only

Vivek12 — Tue, 16 Jan 2024 08:28:55 GMT

Hey

I have an app with operations data for 2-3 years which reloads daily adding in new data for each day.

I need to create a daily report subscription for my users which will show only the previous day data in pdf format. I know that while creating subscriptions whatever filter selection you have , the report will be generated for that selection only

But in my case, I would need a dynamic filter selection which will show previous day selection only irrespective of the current date.

Does anyone know the way to do this?
I tried dynamic filtering using bookmarks or sheet actions but those are not getting reflected in the subscription . Not sure if I missed something over there . May be possible with Qlik automation but can't figure out how to set up blocks for it
Any help would be highly appreciated

Re: Sheet subscription for previous day date filter only

ysalvi — Tue, 16 Jan 2024 09:40:20 GMT

I guess it is possible using the Getselectcount function where if there is no date filter selected it will be by default Previous day data and else if any day is selected it will show the previous day of the selected date.

by using set analysis

Thanks and Regards

Re: Sheet subscription for previous day date filter only

Vivek12 — Wed, 17 Jan 2024 11:22:18 GMT

Thanks for mentioning

I forgot to mention that doing this in set analysis is not possible as per client requirement/ other constraints
Is there anyway to do it without set analysis?

Re: Sheet subscription for previous day date filter only

Lech_Miszkiewicz — Thu, 18 Jan 2024 01:39:56 GMT

I would simply implement the flag in load script flagging onl;y previous day as "1" and then applying filter on that flag rather than on actual date.

Re: Sheet subscription for previous day date filter only

Andrew_Kruger — Tue, 30 Jan 2024 17:51:30 GMT

Thanks for the post @Vivek12 - great to see the use case.

From a roadmap perspective we have an item to support dynamic filters in subscription definition. There are a number of priority topics that still remain ahead so can't forecast any timing. @Lech_Miszkiewicz has a great suggestion for the time being.