How to obtain a partial total by dimension

[#1]

Hi all!

Please find image attached:

Mc = Count(total <DESTINAZIONE, MEZZO> MVCDE) * MZPRT // MVCDE and MZPRT are two db fields

Tot Mc = sum(total <DESTINAZIONE> Mc)

Why am I getting 0 values as result? I don't understand where I'm making mistake, the red values shown in figure are the result I would expect...

Do you need to know more details about db structure?

Thanks in advance.

--

Marco Pikiri

[#2]

Yes, i.e. the column after "DESTINAZIONE" dimension.

After "Mc" there is "Tot Mc" expression that is the sum of "Mc" values grouped by "DESTINAZIONE" dimension.

[giakoum]

somehting like the attached?

[#4]

In the attached, "Tot Mc" is not correct, but "Tot Mc new" almost.

I say almost because I would expect the same values also for "DUMPER 2" MEZZO, and not a series of 0..

Anyhow... ... what a concatenation of functions! But where could I start to understand the logic behind this solution? i.e., which could be the best approach?

[giakoum · Accepted solution]

Sum(total<DESTINAZIONE> aggr(distinct Count(MVCDE)*MZPRT, DESTINAZIONE, MEZZO))

http://community.qlik.com/thread/61292

[#6]

Thank you very much! This is the expected result!!!

[giakoum]

Dont thank me! Whiteline is to thank!