Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression for total count in different status flag

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....

1 Reply
Not applicable
Author

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!!