Spliting by BusinessDay

[#1]

@ 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

[joseduque]

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?

[MK9885]

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.

[rahulpawarb]

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

[#5]

Hi Jose

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

Please assist if you have examples

Thanks