Discussion Board for collaboration on QlikView Layout & Visualizations.
Hi I have below requirement
Please find below offset logic whihc needs to added to totals above
Final View should be as below
Please suggest how to implement this at UI level or Script level
Thnaks in advance
I used this script to create a lookup table that you would manually populate and adjust for each offset.
The offset contains the multiplier '-1' and maps in the offsets. The chart expression is just:
sum( [Total] * multiplier)
(ooxml, embedded labels, table is Sheet1);
//map all sources to themselves
Sources as MappingSource,
1 as Multiplier
//Add additional offsets manually
LOAD * INLINE [
Sources, MappingSource, Multiplier
SR6, SR2, -1
SR7, SR2, -1
SR8, SR3, -1
I have created mapping table based on your suggestion.
But total is not linking correctly for the new MappingSource column. Total value is same for all the sources
I'm looking for following output
Please suggest. Thanks in advance
are you using the qvw i provided ?