Trying to use p() function

Tue, 22 Nov 2011 12:20:58 GMT

I have created a straight table which incorporates the following expression as "First"

sum ( { $<YearPeriod={'2010 01'}>} LineValue)

and I get the following result

Group	YearPeriod	Sum	First
Cans	201001	308,730	308,730
Solvent	201001	311,696	311,696
Metal	201001	366,314	366,314
Resin	201001	848,321	848,321
General	201001	911,037	911,037
Cans	201002	321,608	0
Solvent	201002	356,758	0
Metal	201002	442,505	0
Resin	201002	950,234	0
General	201002	955,710	0
Cans	201003	378,945	0
Metal	201003	394,861	0
Solvent	201003	403,648	0
Resin	201003	1,082,186	0
General	201003	1,129,212	0
Cans	201004	374,603	0
Solvent	201004	380,656	0
Metal	201004	567,926	0
General	201004	1,076,636	0
Resin	201004	1,114,354	0
Cans	201005	409,935	0
Solvent	201005	485,422	0
Metal	201005	646,620	0
General	201005	1,039,303	0
Resin	201005	1,310,015	0

But what I actually want is this...

Group	YearPeriod	Sum	First
Cans	201001	308,730	308,730
Solvent	201001	311,696	311,696
Metal	201001	366,314	366,314
Resin	201001	848,321	848,321
General	201001	911,037	911,037
Cans	201002	321,608	308,730
Solvent	201002	356,758	311,696
Metal	201002	442,505	366,314
Resin	201002	950,234	848,321
General	201002	955,710	911,037
Cans	201003	378,945	308,730
Metal	201003	394,861	311,696
Solvent	201003	403,648	366,314
Resin	201003	1,082,186	848,321
General	201003	1,129,212	911,037
Cans	201004	374,603	308,730
Solvent	201004	380,656	311,696
Metal	201004	567,926	366,314
General	201004	1,076,636	848,321
Resin	201004	1,114,354	911,037
Cans	201005	409,935	308,730
Solvent	201005	485,422	311,696
Metal	201005	646,620	366,314
General	201005	1,039,303	848,321
Resin	201005	1,310,015	911,037

How do I apply the p() function to make this work?

Thanks

QlikView for Windows Version 9.00.7646.9 SR6

(Just as an aside, is there a preferred browser or some add-in I should be running, as I find the messaging on this forum extremely slow and difficult to use? It has taken me 15 minutes or more to compile this message.)

Trying to use p() function

swuehl — Tue, 22 Nov 2011 12:45:51 GMT

I don't think you need the p() function here, but a total qualifier, maybe like

=sum ( { $<YearPeriod={'201001'}>} total<Group> Sum)

Regards,

Stefan

P.S.

I use Firefox on WindowsXP, and this works quite nicely, but I have heared of some issues with browsers and the forum.

Trying to use p() function

Tue, 22 Nov 2011 12:55:21 GMT

Oh my good God!!!

That is so brilliant Stefan, and so simple.

I have gone round so many houses trying combinations of set analysis and group functions and made zero progress, hence my venture in indirect set analysis.

I think this might just have kicked one of the doors down for me.

Many thanks!

topic Trying to use p() function in QlikView

Trying to use p() function

Trying to use p() function

Trying to use p() function