topic Re: Extraction SpecificDate in QlikView

Extraction SpecificDate

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I have Table that contains A date field as General Form i.e. "42736" I need to extract the first 20 days in from each month ,

how can I write this in the script.

Thank you

hope you can help

Anil_Babu_Samineni — Thu, 19 Oct 2017 15:12:56 GMT

Perhaps this? Arrange as per your needs

LOAD AutoNumber(RecNo(), Month(Date)) as ID,Month(Date) as Month, Date Where AutoNumber(RecNo(), Month(Date)) <= 20;

LOAD Date(MinDate + IterNo() - 1) as Date

While Date(MinDate + IterNo() - 1) < MaxDate;

LOAD MakeDate(2014) as MinDate,

MakeDate(2015) as MaxDate

AutoGenerate 1;

MarcoWedel — Thu, 19 Oct 2017 21:37:49 GMT

please post some more sample data and your expected result.

thanks

regards

Marco

mario-sarkis — Fri, 20 Oct 2017 09:20:59 GMT

Dears , I solve it by Using that "DAY" Function and I extracted my Data with the condition of where Day < 20

Thanks