Discussion Board for collaboration on QlikView Scripting.
This is the Snapshot of the data I have:
As per "criteria_name" each Internal Business Unit is linked to each Internal Legal Entity, so here we have 6 Business Unit and 2 Legal Entity which should result in a set of 12 rows (Output).
We can consider "current_exposure" to take the vale from Internal Business Unit row.
Such condition exist for each "exp_line_id", for the sake for example i have only considered one "exp_line_id".
How can i achieve this output?
This is like reverse CrossTable, but more complex:
Row values as fields (opposite of crosstable?)
Go to Solution.
try like below
short_name as "Internal Business Unit",
where criteria_name='Internal Business Unit';
short_name as "Internal Legal Entity",
where criteria_name='Internal Legal Entity';
View solution in original post
Thanks for the smart solution, no doubt you are an MVP