Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I use code :
(Sum({<TypeStatus={'OUTER'},[Time - Month]=,[Time - Day]= >} Aggr( Input_SQFT,WO_WorkOrderNo,[Time - Month])))+Sum({<TypeStatus={'PLATE_PANEL'} ,[Time - Month]=,[Time - Day]= >} Aggr( Input_SQFT,WO_WorkOrderNo,[Time - Month]))+Sum({<TypeStatus={'AFTER_PRESS'} ,[Time - Month]=,[Time - Day]= >} Aggr( Input_SQFT,WO_WorkOrderNo,[Time - Month]))
Result :
I'd like to have it show up every month. Ignore the selected date and month.
I want to show the whole month's data of every month. [Time - Month]= ,[Time - Day]= >
Hi
See this page explaning the use of NODISTINCT qualifier in AGRR() function
https://community.qlik.com/t5/Design/The-nodistinct-qualifier-and-the-Aggr-function/ba-p/1535332
What must I do? The resulting values will come out the way want.