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: 
Vince_CH
Creator III
Creator III

Running of total sum value in measures regardless of the selection

Hello All,

I have a table like below, with sales being the total service income, and machine & machine value are the machine qty and value each customer has.  I intend to have the service income selected by the year, and the machine qty  and value kept in total regardless of the selection.  My expressions for machine qty like following, but when I selected by certain year, the machine qty turns zeor, with actual total should 8 instead.  How can I do it?   thanks in advance!

Sum({<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'}>}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))

11.jpg

5 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi,
Do you mean you want to ignore the Year selections?
if yes, please add [Year]= into your set analysis.
Aiolos Zhao
pradosh_thakur
Master II
Master II

Sum(total<year>  {<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'}>}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))
Learning never stops.
pradosh_thakur
Master II
Master II

Sum({<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'},Year = >}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))
Learning never stops.
Vince_CH
Creator III
Creator III
Author

Gents, thanks for replies. I have tried following earlier, but when I selected certain fiscalyear, the result is zero still.

Sum({<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'},FiscalYear = >}Aggr(Order_Item_Quantity,[Order No.],[Item Number]))
pradosh_thakur
Master II
Master II

You tried this as well.

Sum(total<year>  {<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'}>}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))
Learning never stops.