topic Re: Set Analysis for counts in QlikView

Set Analysis for counts

Sun, 22 Sep 2013 19:07:15 GMT

Hi everybody

I have to do a expression for following scenario:

Month of Juy - 1000 Accounts Created - Count (Account Id for the month of July)

I would like to have the transaction for those 1000 accounts from July 1st to August 31 st

No of Transactions for Accounts created in month of July for the period of July 1st - August 31st

Thnank you,

Abhi

Re: Set Analysis for counts

Mon, 23 Sep 2013 02:53:54 GMT

hmm... if you ask me, I will do it by aggregations other than Set analysis...

SUM(Aggr(if(AccCreateDate>='1-Jul' AND AccCreateDate<= '31-Aug', 1, 0), TransactionsID))

What I do here is aggregating through the transactions, if the Account create date is between 1-Jul to 31- Aug return 1 else return 0. After that you can just sum up everything, it should return you what you need.

Re: Set Analysis for counts

tresB — Mon, 23 Sep 2013 04:36:26 GMT

I guess you have to use indirect set analysis p().

Re: Set Analysis for counts

sushil353 — Mon, 23 Sep 2013 05:30:57 GMT

Hi,

Please provide some example/sample application or data to understand your requirement.

HTH

Sushil

Re: Set Analysis for counts

sujeetsingh — Mon, 23 Sep 2013 06:15:57 GMT

Seems you need to explain the scenario .

you can use sum(with If expressions)