Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Set analysis

Hi,

Need set analysis for the below expression,

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


Thanks

1 Solution

Accepted Solutions
sunny_talwar

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
sunny_talwar

Can you try this:

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