Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Comparative Analysis Alternate State Aggr Set Analysis

Hi,

I have the attached Document which looks at the spreadsheet "Transactions.xlsx", I am trying to do the Alternate States using the CustomerNo field but the chart is not changing, the expressions within the chart using Set Analysis and AGGR so I'm not sure if my syntax is right?

Anyone know how to do this?

1 Reply
Highlighted

Re: Comparative Analysis Alternate State Aggr Set Analysis

Try the attached may be

Sum({[Group1]} Aggr(Sum(DISTINCT {[Group1] <[Status] = {'Open'}, [CustomerNo] = [Group1]::[CustomerNo]>} [CreditLimit]), [Order No]))


Sum({[Group2]} Aggr(Sum(DISTINCT {[Group2] <[Status] = {'Open'}, [CustomerNo] = [Group2]::[CustomerNo]>} [CreditLimit]), [Order No]))