I am very new to Qlik and was hoping to get pointed in the the right direction.
I am trying to pull data in from several source systems and am seeing differences combined business units in one source but not in others. Source A has business unit at the most granular level (Unit A, Unit B, Unit C, etc). However, Source B has combined some units (Unit A + Unit B = Unit X) so I can't get to the individual unit level.
My goal is to have a unified dashboard with Source A and Source B in their own charts. A user selecting Unit A from a listbox would see the chart such as:
Dashboard:
Chart A with Source A data = Unit A chart data
Chart B with Source B data = Unit X chart data
Can this be done?
Source Data:
Source A
unit
Metric
Value
Unit A
APPS
7
Unit B
APPS
12
Unit C
APPS
3
Source B (where Unit A and Unit B have been combined as Unit X)
