topic Re: Help to aggr a result in QlikView

Help to aggr a result

Thu, 14 Mar 2013 10:29:05 GMT

Hi guys,

I'm in trouble with an aggregation.

I have a straight table with two dimension and one expression:

nominativoD	nominativoR	GAP -1
Berti Valter	Avondoglio Marco	1
Berti Valter	Beldi' Paola	0
Berti Valter	Cotto Giovanni	0
Berti Valter	Diretti Berti Valter	0
Berti Valter	Morera Maurizio	2
Berti Valter	Valperga Giovanni	0

the expression for GAP-1 is:

if(

sum(

if(annomese_MNG=$(vTrimAct_MNG), left(ConsAvanzata,1))

)

sum(

if(annomese_MNG=$(vTrimPrec_MNG), left(ConsAvanzata,1))

)

=-1

)

I'd like to have a table with only one dimension "nominativoD" and aggr the result of GAP-1.

In poor words I'd like to have a table like this:

nominativoD	GAP -1
Berti Valter	3

How can I change my expression to reach my goal ??

Thank you so much in advance

Giampiero

My question is in the attached image.

Re: Help to aggr a result

Anonymous — Thu, 14 Mar 2013 10:39:37 GMT

use this expression in chart

aggr(if(sum(if(annomese_MNG=$(vTrimAct_MNG), left(ConsAvanzata,1)) - sum(if(annomese_MNG=$(vTrimPrec_MNG), left(ConsAvanzata,1)))=-1,1,0) , nominativoD )

add only single dimension nominativoD

Regards,

anant

Re: Help to aggr a result

Gysbert_Wassenaar — Thu, 14 Mar 2013 10:42:11 GMT

Try

sum(aggr(

if( sum(if(annomese_MNG=$(vTrimAct_MNG), left(ConsAvanzata,1))) -

sum(if(annomese_MNG=$(vTrimPrec_MNG), left(ConsAvanzata,1))) =-1,

0),nominativoRM))

Re: Help to aggr a result

Thu, 14 Mar 2013 10:44:29 GMT

Hi,

Can you please Upload your Application. I will try to solve.

Regards,

Nirmal Raj.

Re: Help to aggr a result

Thu, 14 Mar 2013 11:03:06 GMT

Hi guys,

first of all THANKS to reply.

@ Anant and Gysbert: Unfortunately it doesn't work. The result is 1 and not 3

@ Nirmal Raj: Unfortunately My Qvw is to big and I can't put it on internet. I'll try to create a Qvw similar.

Any other idea ??

I'm really in trouble. I have to show the result today and I don't know how to solve this problem.

THANK YOU SO MUCH

Giampiero

Re: Help to aggr a result

Thu, 14 Mar 2013 11:11:09 GMT

Atleast upload simple sample application.

Re: Help to aggr a result

Thu, 14 Mar 2013 11:59:05 GMT

Hi,

I attach a simple application.

Hope it helps.

Thanks all.

Giampiero

Re: Help to aggr a result

Thu, 14 Mar 2013 12:12:02 GMT

Hi,

Please Find The Attachment hope problem is solved.

Regards,

Nirmal Raj.

Re: Help to aggr a result

Thu, 14 Mar 2013 12:21:31 GMT

Hi,

I Hope This is Exact Output you need.

Regards,

K.J.Nirmal Raj.

Re: Help to aggr a result

Thu, 14 Mar 2013 12:26:32 GMT

Hi,

See this Attched File...........hope your needful has been done.

Regards,

Nirmal Raj.

Re: Help to aggr a result

Thu, 14 Mar 2013 13:18:16 GMT

Thank you so much Nirmal Raj.

It works fine.

Best regards

Giampiero