Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

peterkumar
New Contributor III

QS - Set Analysis

Good Afternoon - 

I will appreciate guidance on the set analysis below.  The first argument works fine, but the second one is being ignored.  

Count({$<[S-Account Mapped]={'Y'}, "=left([S-Date],4)"={'2016'}>}[S-Account Mapped])

Thank You!!

1 Solution

Accepted Solutions

Re: QS - Set Analysis

You can also try this

Count({<[S-Account Mapped] = {'Y'}, [S-Date] = {"=Left(Only({1} [S-Date]), 4) = 2016"}>} [S-Account Mapped])

View solution in original post

3 Replies
jwjackso
Valued Contributor

Re: QS - Set Analysis

I've never done it that way, you might have better luck with:

 

Count({$<[S-Account Mapped]={'Y'}, [S-Date]={">=$(=MakeDate(2016,1,1))<=$(=MakeDate(2016,12,31))"}>}[S-Account Mapped])

Re: QS - Set Analysis

You can also try this

Count({<[S-Account Mapped] = {'Y'}, [S-Date] = {"=Left(Only({1} [S-Date]), 4) = 2016"}>} [S-Account Mapped])

View solution in original post

peterkumar
New Contributor III

Re: QS - Set Analysis

Many thanks Sunny!

That worked fine.