Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
nareshthavidishetty
Contributor III

Set analysis

Hi,

Need set analysis for the below expression,

if(FiscalYear='2016-2017',Count(Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApplication_Date)))


Thanks

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Set analysis

Can you try this:

Count({<FiscalYear = {'2016-2017'}>} Aggr(Count(DISTINCT {<FiscalYear = {'2016-2017'}>} racApplicationNbr), racCustomerID, racApplication_Date))

View solution in original post

1 Reply
Highlighted

Re: Set analysis

Can you try this:

Count({<FiscalYear = {'2016-2017'}>} Aggr(Count(DISTINCT {<FiscalYear = {'2016-2017'}>} racApplicationNbr), racCustomerID, racApplication_Date))

View solution in original post