Discussion Board for collaboration related to QlikView App Development.
I have an excel file in which Field ID, Object, Department, dept these columns are present. I have taken this file with script editor into QV. (please see screenshot )
I wanted to show sum of actual with the object ID in the chart.
ex: take sum of actual if object ID is chart1, chart2 & chart3.
Go to Solution.
Sorry I got the answer.
The answer is
You have data model problem. Fields Object and actual don't have any relation.
To connect tables Categories and KPIS you use composite key FieldID + Dept. And there are no match values combination in both tables