topic Re: set analysis in QlikView

set analysis

Fri, 18 May 2012 18:12:37 GMT

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.

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

Thanks.

mphekin12 — Fri, 18 May 2012 18:19:54 GMT

I hope the attached file helps!

Tue, 22 May 2012 16:36:33 GMT

Hi,

Thanks for your answer!

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

Eva

mphekin12 — Tue, 22 May 2012 17:03:18 GMT

Eva,

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

Tue, 22 May 2012 17:26:06 GMT

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

Tue, 22 May 2012 18:24:16 GMT

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

mphekin12 — Tue, 22 May 2012 18:27:56 GMT

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

Thank you!

Tue, 22 May 2012 18:31:31 GMT

Sure , thanks for your help!!!

mphekin12 — Tue, 22 May 2012 18:33:25 GMT

Thanks Ava!

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