Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashutosh11
Contributor
Contributor

set expression

I'm trying to find this year's sales quantity of  a sub product but showing different value, any help. 

Sum({<FiscalYear=, [Date] = {">$(=yearstart(max([Date]), 0,4)) <$(=yearend(max([Date]), 0,4)) "} >}({<[Main Group]={'ITALIAN'}, [Sub Group]={'PU'}>}Quantity))

Labels (2)
2 Replies
martinpohl
Partner - Master
Partner - Master

Hi,

change to

Sum({<FiscalYear=, [Date] = {">$(=yearstart(max([Date]), 0,4)) <$(=yearend(max([Date]), 0,4)) "} ,[Main Group]={'ITALIAN'}, [Sub Group]={'PU'}>}Quantity))

SunilChauhan
Champion II
Champion II

Sum({<FiscalYear=, [Date] = {">$(=yearstart(max([Date]), 0,4)) <$(=yearend(max([Date]), 0,4)) "} ,[Main Group]={'ITALIAN'}, [Sub Group]={'PU'}>}Quantity)

Sunil Chauhan