Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
okanakdemirci
New Contributor

Need Help For Sum Function

Hi All,

When I make multiple selections on the data model, I want the biggest year's data to be processed. Code structure;

(((Sum({$<Year={"=$(=(Max(Year)))"}, Month={"<=$(=(Max(Month)))"}> } In_Qty)) -

(Sum({$<Year={"=$(=(Max(Year)))"}, Month={"<=$(=(Max(Month)))"}>} Out_Qty))))

When I choose all years sum data for all years but i want the only biggest year in my selection.

Please help me.

Tags (3)
1 Reply
shiveshsingh
Honored Contributor

Re: Need Help For Sum Function

Try removing '=' sign before $ in Year set analysis.

{$<Year={"$(=(Max(Year)))"}