During our building of a Vizlib Finance PnL we have been able to use the standard Vizlib Template with using a Hierarchy Table for Account (D_Account_Node as seen in attachment) and we have been able to create a PnL using the ExtraMappingIntervals to add an additional linkage by Profit Center and Account to our PnL.
Is there a way that we can add a 2nd or 3rd Extra Mapping Interval to the Vizlib template and how will that change the base code to the Vizlib Script that is used?
I have attached a sample of my Vizlib template:
PNL - basic
PNL_FLASH - using 1 Extra Mapping Intervals (added Profit Center)
PNL_FLASH_NEW - This is where I will need help on- adding a 2nd Extra Mapping Intervals (Company)
How do I code it in the Vizlib Script in Qlik?
How do I specify it in the Options tab on the Vizlib Template?
I have indicated in Orange on the PNL_FLASH_NEW & Options page what I am trying to add.
I have also included my Qlik script to create the new table using that 1 Extra Mapping Interval so that it links to my Fact table because in our Fact table we have replaced Account with a %Account so that it creates a reference to a Node table for faster processing.