I am creating a table chart in qlik sense where I need to include two measures and some dimensions. I am doing the slicing and dicing based on team name but it is giving me bad results. I tried the same through straight table using generic load through joining the multiple tables created by generic load to the parent table but it is given Ng me the bad results.
Can anyone help me in this case.
I need these fields in the chart in the following sequence.
Date month, estimate days, estimate cost and team name in the column having distribution of estimate days.
My logic is something like below
Analysis:
Generic Load key,team, estimate days
Resident parent_table;
Logic below for joining the multiple tables to parent table.
I am getting the results but where ever the entry for the estimate days in the team column is needed ,I am getting the same estimate days values instead of distributed values.
Like suppose total estimated days value is 7 and the distribution is like 5 and 2 for two different teams, then instead of 5 and 2 I am getting 7 for both.
Please help me with the pivot table in qliksense
