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

I want to show the whole month's data of every month.

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]))

Sxbbb_3-1689925482748.png

 

 Result :

Sxbbb_2-1689925318084.png

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]= >

 

 

 

2 Replies
brunobertels
Master
Master

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 

Sxbbb
Creator III
Creator III
Author

What must I do? The resulting values will come out the way want.