Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks a lot for the help.
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