Discussion Board for collaboration on QlikView Scripting.
I have a problem where data is being merged within a Qlikview app where the data is entered at 2 different levels in the hierarchy.
The higher level is Factory (CC38)
Business unit is a child of factory.
as a result I need to only produce a single record at CC38 (Factory level) whereas all other data is entered at the lower Business Unit level.
I enclose some example data which should make my issue more understandable.
Many thanks in advance for advice you can give me.
Go to Solution.
Something like this:
FirstValue([Business_Unit]) as [Business_Unit],
(ooxml, embedded labels, table is [Current Data])
Group BY IncidentId,
Great answer - just couldn't "visualise" the FirstValue function
Thanks a lot
Try like this using Group By and Maxstring()
MaxString(Business_Unit) AS Business_Unit
WHERE Len(Trim(IncidentId)) > 0
GROUP BY IncidentId,