Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Group By Specific

I have 10 Fields .

ReferenceNo| username|accountno|profitaccount|balanceaccount| MMC|KPL|LDDR|Amount|MSC


Now I need the sum of Amount as new field name 'Actual Amount'  based on the condition if MMC= 'OK' and LDDR = 'OK' and only grouped by accountno|profitaccount|balanceaccount|..a


In the final output i need all the 10 fields plus the new field  'Actual Amount'



Labels (1)
0 Replies