Discussion Board for collaboration on QlikView Layout & Visualizations.
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)
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..
Please help be guys...
give some idea please..... :-(
Can you please provide the samplw qvw file.
It is not possible to share the application.. do you have any idea to solve this problem
try to put one by one dimension in aggr
check weither are properly made the links
can you explain your solution please.. It is hard to understand
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