Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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!!