Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with Aggr function in set analysis

Hi,

Can anyone please help with this requirement in set analysis.

Condition - [LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}

I want to have this condition in set analysis and show the max of LP past due days  using group by based on customer name

I wrote my expression as

({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>}[LP Days Past Due])

But I'm unable to put max and group by in same expression.

Thanks.

Sachin

1 Reply
MVP
MVP

The max days would be

=max( ({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>}[LP Days Past Due])

and the Amt

=FirstSortedValue({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>} [LP Delinquent Amt], -[LP Days Past Due])

in a chart with dimension Customer.