Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.)
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.
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.
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!