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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Hi,

try to attach the app or sample data

Anonymous
Not applicable
Author

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
Partner - Master III
Partner - Master III

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