topic need help in expression calculation.. in QlikView

need help in expression calculation..

sushil353 — Thu, 22 Sep 2011 12:29:56 GMT

Hi All,

I have a pivot table in which i have to calculate a logic/expression as dimension for %NDFNDR column.. the logic is given below...

the expression is aggregated over test type and measurement type (TT_TYPE,MT_TYPE)

=aggr((Sum(NDFNDR_SUMMARY.TOTAL_FAILURES)/Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS)*100),NDFNDR_SUMMARY.TT_TYPE,NDFNDR_SUMMARY.MT_TYPE,

now the problem is:

Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS) should not be aggregated over TT_TYPE and MT_TYPE. or other ways TT_TYPE and MT_TYPE should not affect the Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS) caculation....

Please help me out,, how to solve this problem...

Thanks in advance..

need help in expression calculation..

sushil353 — Thu, 22 Sep 2011 17:49:16 GMT

Please help be guys...

need help in expression calculation..

sushil353 — Fri, 23 Sep 2011 04:41:37 GMT

give some idea please..... 😞

need help in expression calculation..

kaushiknsolanki — Fri, 23 Sep 2011 05:37:58 GMT

HI,

Can you please provide the samplw qvw file.

Regards,

Kaushik Solanki

Re: need help in expression calculation..

sushil353 — Fri, 23 Sep 2011 07:09:18 GMT

Hi kaushik,

It is not possible to share the application.. do you have any idea to solve this problem

Thanks

need help in expression calculation..

SunilChauhan — Fri, 23 Sep 2011 07:23:58 GMT

aggr( sum(value),fieldname1,fieldname2,fieldname3)

try to put one by one dimension in aggr

also

check weither are properly made the links

Re: need help in expression calculation..

sushil353 — Fri, 23 Sep 2011 07:29:46 GMT

Hi Sunil,

can you explain your solution please.. It is hard to understand

Thanks

need help in expression calculation..

SunilChauhan — Fri, 23 Sep 2011 08:03:26 GMT

check you have propely made a link between table

i mean using proper id

go to control+t and see the link column in both table using rightclick on table preview

if that is ok then

see

aggr( sum(value),fieldname1)

aggr( sum(value),fieldname1,fieldname2)

aggr( sum(value),fieldname1,fieldname2,fieldname3......