Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

TotalCount

Hi All,

Please find attached of the qvd.

What I have to do is I have to show the total count of personcode against m.orgcode and dw.orgcode .

Like eg:

Personcode    M.Orgcode      Dw.orgcode    CountDifference        Count(M.orgcode)    Count(Dw.orgcode)

1                       1                    1    

                          2                    2

                          3                                                   1                          3                         2

2                       4                    4                              0                          1                         1

3                       5                    5

                          6                    6                              0                          2                         2

sum:                                                                                                   6                          5

Please Suggest how to do it..

Thanks,

Sandeepa

1 Reply
its_anandrjs

Hi,

Use Count ( Total personcode ) to so total value of the personcode

Let me know if not works.

HTH

Regards

Anand