Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

need help in expression calculation..

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....

test.JPG

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

Thanks in advance..

7 Replies
sushil353
Honored Contributor II

need help in expression calculation..

Please help be guys...

sushil353
Honored Contributor II

need help in expression calculation..

give some idea please.....  :-(

need help in expression calculation..

HI,

    Can you please provide the samplw qvw file.

Regards,

Kaushik Solanki

sushil353
Honored Contributor II

Re: need help in expression calculation..

Hi kaushik,

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

Thanks

chauhans85
Esteemed Contributor

need help in expression calculation..

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

try to put one by one dimension in aggr

also

check weither are properly made the links

sushil353
Honored Contributor II

Re: need help in expression calculation..

Hi Sunil,

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

Thanks

chauhans85
Esteemed Contributor

need help in expression calculation..

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)

or

aggr( sum(value),fieldname1,fieldname2)

or

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

Community Browser