Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rxp03570
Creator
Creator

Count using two dimension fields

Hi All,

 

I'm trying to get the Count of Products but I would need to aggregate it with Date and Account ID fields - is the below expression correct?

Count(Aggr(Count(Products),Date,Account_ID)Products).

 

Can anyone please help with the expression.

 

Thanks,

Rahul

Labels (3)
2 Replies
Lauri
Specialist
Specialist

Change to this for the correct syntax:

Count(Aggr(Count(Products),Date,Account_ID))

But I'm not sure if this gets you useful data. It's basically the count of different values of Date and Account_ID. Do you need the count of Products for each Date and Account_ID?

rxp03570
Creator
Creator
Author

Hi Lauri,

Yes, I would require Count of products for each date and acc_id.