Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
swuehl
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.