Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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'

 

Thanks

Labels (1)
0 Replies