expression for total count in different status flag

Wed, 23 Nov 2011 22:09:04 GMT

Hello,

I am new to qlikview and normally use Partial Sum function to sum all values in the columns.

Let's take a look at below example.

(Table 1) : #Count(Applicants) where ApplicantStatus='Booked','Rejected'

Jan-11 Feb-11

Flag=1 Counr(Applicants)=3 (A1) Counr(Applicants)=4 (B1)

Flag=2 Counr(Applicants)=2 (A2) Counr(Applicants)=2 (B2)

Total Counr(Applicants)=5 (A3) Counr(Applicants)=6 (B3)

Expression: Count ({<ApplicantStatus={'Booked','Rejected'}>}ApplicantID)

The Total row derives from Partial Sum function

However, I'd like to build Table 2 by using information from Table 1.

(Table 2) : %TTD Distribution

Jan-11 Feb-11

Flag=1 A1/A3 B1/B3

Flag=2 A2/A3 B2/B3

Total A3/A3 B3/B3

I'd like to know what is an expression for table 2.

Should it be Count ({<ApplicantStatus={'Booked','Rejected'}>}ApplicantID) / sum(total count) ?

By the way, I don't know what is an expression for sum(total count).

Anybody can help me? Many thanks....

Wed, 23 Nov 2011 22:35:44 GMT

Oh, and morever I'd like to create another seperated table, which are annual sum for each Flag.

Like this

(Table 3) : Annual Sum

YTD2009 YTD2010 YTD2011

Flag=1 1234 2345 A1+B1+...+L1

Flag=2 2344 3556 A2+B2+...+L2

Total 3578 5901 Sum

I'd like this table to show the value whenever only Table 1 and 2 contain in total 12 columns (Jan to Dec).

How could I do that?

I would very much appreciate for your answer!

Thank you very much!!

topic expression for total count in different status flag in QlikView