Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
piyush_s11
Contributor

Sum Value of max date per ID

Hi

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 )

Image.PNG

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.

 

1 Solution

Accepted Solutions
piyush_s11
Contributor

Re: Sum Value of max date per ID

Sorry I got the answer.

 

The answer is 

=sum({<ObjectID={'CHART2','CHART3','CHART1'},Dept={Dept1},[Month] ={"<=$(=GetFieldSelections([Month]))"}>}Actual)

2 Replies
mrybalko
Contributor II

Re: Sum Value of max date per ID

You have data model problem. Fields Object and actual don't have any relation.

Снимок.JPG

To connect tables Categories and KPIS you use composite key FieldID + Dept. And there are no match values combination in both tables

model.JPG

piyush_s11
Contributor

Re: Sum Value of max date per ID

Sorry I got the answer.

 

The answer is 

=sum({<ObjectID={'CHART2','CHART3','CHART1'},Dept={Dept1},[Month] ={"<=$(=GetFieldSelections([Month]))"}>}Actual)