topic Re: Next 7 Days in QlikView

Next 7 Days

beck_bakytbek — Sat, 16 Nov 2024 21:50:28 GMT

Hi Folks,

i got a situation: (please see the attached screenshot), i create the master calender where i have 3 Years: 2019, 2018, 2017, Quarters, Days.

i have a question: how can i show in set expression: the next 3 Day in Year: 2019, with Years i dont have any problems, because it is possible by using of this expression: count({<Year = {"$(=max(Year))"}>}contract), but how can i make it possible with days.

Does anybody have any idea?

Thanks a lot

Beck

Re: Next 7 Days

Anil_Babu_Samineni — Thu, 22 Nov 2018 23:13:55 GMT

You mean to say 7th, 8th and 9th Days from Feb months in 2019 ??

Re: Next 7 Days

beck_bakytbek — Fri, 23 Nov 2018 08:37:31 GMT

Yes, my expected Output is: for instance Show me the amount of contracts for next 3 days

Re: Next 7 Days

Anil_Babu_Samineni — Fri, 23 Nov 2018 09:02:06 GMT

Do you have the data for that or you want to predict?

Re: Next 7 Days

beck_bakytbek — Fri, 23 Nov 2018 09:06:00 GMT

Hi Loveisfail,

first of all, thanks a lot for your time and help. my data you can see in attached screenshot, my Situation does look like: i have an Appointment in 2019 and in 2019 i should solve for instance 5 contracts,

i want only Show dynamic on day, Monthly or quartes Basis the amount of contracts in 2019

Thanks a lot

Re: Next 7 Days

Anil_Babu_Samineni — Fri, 23 Nov 2018 09:08:34 GMT

I am sorry, Still not getting the idea of requirement. But, can you try this - If you may think this way

count({<Year = {"$(=max(Year))"}, Date={">=$(=Date(Max(Date)+3))<=$(=Date(Max(Date)))"}>}contract)

Re: Next 7 Days

beck_bakytbek — Fri, 23 Nov 2018 09:10:35 GMT

Hi Loveisfail,

Thanks a lot for your feedback

just imagine: today we have 2018 and i want to Show only the values for 2019, the data you see in attached screenshot

Re: Next 7 Days

Anil_Babu_Samineni — Fri, 23 Nov 2018 09:15:20 GMT

This is the case your expression works - If you have data for next year as well
count({<Year = {"$(=max(Year))"}>}contract) // Because, Max(Year) will return 2019 data only if you have till 2019 data. If still you have data more than 2019 as well then you can simplify using this

count({<Year = {"$(=max(Year))"}, Date = {"$('<=' & Date(Today(),'DD.MM.YYYY'))"}>}contract) // This always return till today's data for only 2019 year

count({<Year = {"$(=max(Year))"}, Date = {"$('<=' & Date(YearEnd(Today()),'DD.MM.YYYY'))"}>}contract)

Re: Next 7 Days

beck_bakytbek — Fri, 23 Nov 2018 09:29:33 GMT

Hi Loveisfail,

thanks a lot for your time and Feedback, i will try to implement it and report you when i achieve any positive results.

Thanks a lot for your help