Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

chinmayakumarda
New Contributor

Total Count Values is not Showing For All Same Value

Hello ,

I am creating an expression which will give me the total no of column1 present for customer like if i have 3 invoice for one customer it should show 3 for all the customer but now im able to get only in one row.

Can you please help me out on the same?

Expression:aggr( count( CT_InvoiceId),CT_CustomerId)

3 Replies
YoussefBelloum
Esteemed Contributor

Re: Total Count Values is not Showing For All Same Value

Hi,

try to attach the app or sample data

chinmayakumarda
New Contributor

Re: Total Count Values is not Showing For All Same Value

In the Image you can see, there are 3 rows and has the same customer and whenever im doing the aggr(count(ctinoiceid),customerid) then it shows 3 rows which is right but its showing in 2nd rows, but i want in all rows.

shraddha_g
Honored Contributor III

Re: Total Count Values is not Showing For All Same Value

in "aggr( count( CT_InvoiceId),CT_CustomerId)" this expression add all other Dimensions present in table

Community Browser