topic Re: Spliting by BusinessDay in QlikView

Spliting by BusinessDay

Wed, 25 Nov 2020 16:16:04 GMT

@ Morning Community

I have a requirement for a client :

I am sourcing data from SAP into a Qlikview Extractor , For analysis Person the client wants me to split data by Business Days .

This is a process of three days each month (meaning i report on Three days).

So what i want to achieve , when i get data for example if i get data today i assign the data to 1 , tomorrow i assign the data to 2 etc .

How can achive this community ?

Regards

Re: Spliting by BusinessDay

joseduque — Fri, 23 Dec 2016 16:44:22 GMT

Hi,

Can you be more specific, What you want to do do is that when you reload the data the first reload goes to day 1, and if you do another reload like tomorrow this goes to day 2?

If so this days are random or you have specific dates likes:

Day 1 always first day of the month

Day 2 always 15th day of the month?

Re: Spliting by BusinessDay

MK9885 — Fri, 23 Dec 2016 16:54:20 GMT

Maybe you need to save those 3 day data in 3 different qvd's and store it.

Later for reporting purpose for Day1 use QVD1, for Day2 use QVD2.....

Manually it is possible, each time while extracting the data just rename the QVD name in script. But if you aiming it to be automatic then I'm not sure how to do this.

Ex:

Day1

Store YourTableNameHere into YourFolderDestinationhere\Day1.qvd

Day2

Store YourTableNameHere into YourFolderDestinationhere\Day2.qvd

Day3

Store YourTableNameHere into YourFolderDestinationhere\Day3.qvd

You can make 3 different reports or have it in single report but differentiating it with different dates.

Re: Spliting by BusinessDay

rahulpawarb — Sat, 24 Dec 2016 11:22:50 GMT

Hello Nemuthenga,

You can maintain a variable vDay (definition: Day(Today()) ) to maintain the day value based on system date; then you can consume it i.e. $(vDay) while generating QVD/storing data by keeping a field with this value for identification purpose.

Hope this will help!

Regards!

Rahul

Re: Spliting by BusinessDay

Thu, 12 Jan 2017 12:00:42 GMT

Hi Jose

Sorry for replying late , yes you got it right thats exactly what i want .

Please assist if you have examples

Thanks