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

set analysis

Hi,

I think I need to use it, but I not sure how.

I did an example attached, I would like add the column "Need" it's just the Total by Country and Month.

I would like have this graph.

CountryMonthProductAABBTotal
MetricNeedMetricNeed
canada011233293232
canada022618121818
france01119899
france022516111616
usa011414101414
usa022720132020

I tried many formula...Could you help me?

Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

= aggr(NODISTINCT Sum (Metric), Country, Month) works

View solution in original post

8 Replies
mphekin12
Specialist
Specialist

I hope the attached file helps!

Not applicable
Author

Hi,

Thanks for your answer!

but in fact I need to display  the total in each column.

Eva

mphekin12
Specialist
Specialist

Eva,

Try this one.  I added a new chart called 'Country/Month Total - 2' that displays the total (need) after each product.

Not applicable
Author

thanks,

It's working in the example thanks. But I cannot multiply the number of metrics. I Have maybe 1 000 products .

I tried that : =aggr(Sum(Metric),Country,Month)

It's working for the first column but I cannot replicate for all of them.

Eva

Not applicable
Author

= aggr(NODISTINCT Sum (Metric), Country, Month) works

mphekin12
Specialist
Specialist

Can you post your sample using the formula above so I can understand the solution?

Thank you!

Not applicable
Author

Sure , thanks for your help!!!

mphekin12
Specialist
Specialist

Thanks Ava!

I’m glad someone was able to help you with your issue.