Set analyis question.

Mon, 14 Nov 2011 19:41:06 GMT

Hello,

I have the following formula (Expression) in pivot table:

sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { 'SKW-ID-FS' } >} ISAmount3)

Essentially I am summing the information from another table which has no links to anything. The above works just fine, however when I do the following I get the sum of zero. NOTE: The section I am interested in is the ISOrg3 which changes by row.

sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { $(=RTaskOrg) } >} ISAmount3)

The value of RTaskOrg is another expression contained within the pivot table. I have tried the following but no results:

sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { $(=MaxString(RTaskOrg)) } >} ISAmount3)

sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={$(=Only(Period3))}, ISOrg3 = { $(=Column(7)) } >} ISAmount3)

Any ideas?

Thanks,

Set analyis question.

Tue, 15 Nov 2011 00:27:29 GMT

Does adding quotes around your $() help?

sum({<ISGroup3={'Total Indirects'}, PeriodType3 ={'Current'}, Period4={"$(=Only(Period3))"}, ISOrg3 = { "$(=RTaskOrg)" } >} ISAmount3)

Re: Set analyis question.

Tue, 15 Nov 2011 14:43:55 GMT

That works! Thanks.

topic Set analyis question. in QlikView

Set analyis question.

Set analyis question.

Re: Set analyis question.