Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

sales value in SKU wise

Hi all,

I am using the formula =Sum({$<Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))},Years=,Months= >}Sales)

and i am getting the overall sales value for all SKU.

i want sales value for one SKU to be displayed without selecting a particular SKU.

Anyone help me.

Thanks in Advance

Regards,

Joshua.

11 Replies
tresesco
MVP
MVP

May be this?

=

If(GetSelectedCount(SKU)>0,

          Sum({$<Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales) ,

          Sum({$< SKU ={SKUValue1},Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales)

)

ajsjoshua
Specialist
Specialist
Author

Thank u tresesco its working fine.

Regards,

Joshua.