topic Re: Script Level | Prev Values Mapping to missing values in QlikView

Script Level | Prev Values Mapping to missing values

Surya — Thu, 10 Nov 2022 07:26:28 GMT

I have followed

"Date",
"Year",
"Month",
Dealer_Code,
Applymap('Dealer_Name',Dealer_Code,'NA') as Dealer_Name,
Series,
open_booking

-------------------------

I need to pick Every month 25th Date from this table. But 25th Sep is Sunday and the date is not available in this table.

sow in case of 2th is not available i need to pick 24th Data .

Please help to solve this.

Re: Script Level | Prev Values Mapping to missing values

marcus_sommer — Fri, 11 Nov 2022 15:52:26 GMT

You could use a master-calendar to maintain the information which date is a working date or weekend or holiday - as string-value but also as 0/1 value and further it could be cumulated per month. Now you may query this information within your table, for example with a more/less nested mapping or within any objects with if-loops but you may also create an appropriate flag directly within the calendar.

- Marcus

Re: Script Level | Prev Values Mapping to missing values

Ryan69 — Tue, 15 Nov 2022 10:18:06 GMT

@marcus_sommer wrote: LA Fitness Employee Portal

You could use a master-calendar to maintain the information which date is a working date or weekend or holiday - as string-value but also as 0/1 value and further it could be cumulated per month. Now you may query this information within your table, for example with a more/less nested mapping or within any objects with if-loops but you may also create an appropriate flag directly within the calendar.

- Marcus

Thanks for the information, I will try to figure it out for more.