Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dates, columns to rows, Scripting help needed

Hello All,

I have a complex requirement, any suggestion is much appreciated.

What I have:

A file with Monthly values, e.g: For a Line of Business A, June Amount is xxx $

I have a Qlikview dashboard with Facts and Dimensions and this file has to be handled directly by Qlikview but rest of the tables come from a database

A single LOB can have multiple Entities

What I need:

I will have to split the Monthly amount into Weeks and then into days omitting the weekends

I will have to introduce the dates according to the month mentioned in the file e.g. for June 2016, i will have to introduce dates for weekdays.

I will have to introduce rows for each date and for each LOB and each Entity

Please refer to the attached excel and let me know if more information is needed.

Thanks,

Ga

12 Replies
puttemans
Specialist
Specialist

Hello Ga,

Please find attached the example based on your newest documents. It needed a tweak because of the crosstable you want to load.

I've also added one column extra in the input-file for the number of days (NRDAYOFWEEK). If you're not able to add this line in your basic input, you may need to calculate it first within the application.

Kind regards,

Johan

Not applicable
Author

Thanks a lot for the help.

Not applicable
Author

Let me try to calculate the Number of days in a week at Script level. I will reach out to you, if i fail at it.Thanks again