topic Re: Set Analysis within a Set analysis in QlikView

Set Analysis within a Set analysis

Anonymous — Wed, 27 May 2015 20:19:18 GMT

I have a field comprised of dates within November and December of 2013:

Posting Date = '11/1/2013','11/9/2013','12/23/2013','12/30/2013'

Instead of putting the dates as individually as it might change, I want to use the fields

Year = 2013

Period = 11,12

So its November and December in 2013.

in set analysis it would be

=sum({$ <

[Year] = {2013},

[Period] = {11,12}

>}[Posting Date])

The Posting Date is a field I am using in a set analysis:

=sum({$ <

[Subject to cut off] = {'Yes'},

[Posting Date] = {'11/1/2013','11/9/2013','12/23/2013','12/30/2013'},

[Revenue recognized] = {'Yes'},

>}[Document amount])

Basically, I want to put the Posting Date calculated by set analysis within the set analysis calculating Document Amount. Does anybody know how to do this? Thank you in advance.

Re: Set Analysis within a Set analysis

Qrishna — Wed, 27 May 2015 20:35:44 GMT

Do this:

In your script:

YEAR([Posting Date]) AS YEAR

DATE([Posting Date],'M') AS PERIOD //you can also use other Month functions which returns the Month number//

Modify Your expression as

sum({$ <[Subject to cut off] = {'Yes'},

YEAR = {'2013'},[Period] = {11,12}

[Revenue recognized] = {'Yes'},

>}[Document amount])

let me know how it goes.

Thanks

Re: Set Analysis within a Set analysis

Clever_Anjos — Wed, 27 May 2015 20:35:56 GMT

Are you sure that

=sum({$ <

[Year] = {2013},

[Period] = {11,12}

>}[Posting Date]) returns '11/1/2013','11/9/2013','12/23/2013','12/30/2013', maybe CONCAT()?

Re: Set Analysis within a Set analysis

Anonymous — Thu, 28 May 2015 13:02:33 GMT

Your answer worked. Thank you for your help. For everybody else, Thank you for your help as well.