Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. 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