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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Champion III
Champion III

Hi,

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

Let me know if not works.

HTH

Regards

Anand