How do I handle aggregations (max,sum) and group by clause in datamart - using compose version 2024.12
Hi ,
I am new to Qlik compose, I am trying to create a Datamart table which contains data from the compose Datawarehouse tables. I have some of the columns mapped directly but few columns based on the CASE statements along with MAX needs to be mapped , but somehow that is not working in data mart section.
case statements looks like this: max(case when name='aaa' then id end) as primary id
Tried below options , but no luck
option 1: Creating views in compose Datawarehouse and tried accessing them in model , but we can only access landing zone tables/views in model section not the Datawarehouse tables/views.
option 2: tried writing expressions on the Datamart attribute section , throwing error
