topic Re: set analysis issue in QlikView

set analysis issue

singhcv123 — Wed, 30 Mar 2016 09:36:46 GMT

Hi ,

I want to create a set analysis with below data:

Fields Name : Period Number , Year , person

Set analysis for Current Period

Count( {<$Period Number =>}Person)

In Second Set Analysis i want to pick the period code --1 from above value

Count ({<Period Number = {$(Period Number -1 }>}Person)

and in 3rd i want the same period number but last year

Count ({Period Number = , Year ( Addyears(Today()-1)}Person)

Kindly suggest the right combination....i am not getting right outcome from the same..................

swuehl — Wed, 30 Mar 2016 11:35:39 GMT

Try

Count ({<Period Number = {$(=Max(Period Number) -1)}>}Person)

resp.

Count ({<Period Number = {$(=Max(Period Number))}, Year = {$(=Max(Year)-1)}>} Person)

sunny_talwar — Wed, 30 Mar 2016 11:37:56 GMT

Do you have a sample you can share? Are you using this in a text box object or a chart? If it is a chart what is your dimension? Period Number?

Chanty4u — Wed, 30 Mar 2016 11:40:01 GMT

chk dis

Count ({<Period Number = {$(=Max(Period Number) -1)}>}Person)

Kushal_Chawda — Wed, 30 Mar 2016 11:40:17 GMT

Current Period:

Count( {<[Period Number] = {"$(=max([Period Number]))"}>}Person)

Previous Period:

Count( {<[Period Number] = {"$(=max([Period Number])-1)"}>}Person)

Last Year:

Count( {<[Period Number] = {"$(=addyears(max([Period Number]),-1))"}>}Person)