Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lprasanth
Contributor II
Contributor II

writing aggr in the load using groupby

can you guys help me out to group the following function in the load

sum(aggr(average_forecast_a_Forecast * $(vfilter5bis),key_OCSXXXXA))

vfilter5bis=if([~filter5]='UC',nb_cu_per_case_Forecast,if([~filter5]='UL',1,if([~filter5]='KG',case_net_weight_Forecast,if([~filter5]='Tonne',case_net_weight_Forecast/1000))))

highlighted are fields from other tables

filter5:
Load * Inline [
~filter5, idfilter5
UC, 1
UL, 2
KG, 3
Tonne, 4
];

Labels (2)
1 Reply
sunny_talwar

Would you be able to share a sample for us to look at this?