Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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.