Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sushil353
Master II
Master II

need help related to set analysis...

Hi Experts,

In my application i have concat 3 fact tables and there are 3 dimension table in association..

fact tables are 1. defect_yield_op_type_summary

                       2. measurement_summary

                       3. op_defect_summary

and dimensions are location,time,defect_type

all the field in first two fact tables are same but there is a difference in one field in third fact table (defect_type)

now i have created a straight table in which location is dimension and expressions are as follows

sum({<source={'defect_yield_op_type_summary'}>} total_defects) and sum({<source={'op_defect_summary'}>} total_defects)

I have attached my sample application which is very easy to understand

My problem is whenever i select defect type to ndf or ndr data for first expression become zero....

I need a expression such that expression one should have no effect when i select ndf or ndr

Please help me out ... this problem sucked my whole day..

Thanks

1 Solution

Accepted Solutions
dwh1104
Creator II
Creator II

Add "defect_type= " to your set analysis statement.  See below...

sum({$<source={'defect_yield_op_type_summary'},

defect_type= >}total_defects)

Thanks,

Dan

View solution in original post

2 Replies
dwh1104
Creator II
Creator II

Add "defect_type= " to your set analysis statement.  See below...

sum({$<source={'defect_yield_op_type_summary'},

defect_type= >}total_defects)

Thanks,

Dan

Not applicable

Hi Sushil,

In you application it seems the relation between the fact_table_summary and defect_type is not properly set.

I have attached a screenshot to show this fact.

In there I have used a table box to find the relation between defect_type and Source='defect_yield_op_type_summary'.

Hence that is why your results shows zero for defect_op_yield_summary field in the straight table.

Should you have further queries please feel free to ask.

Thanks,

Bikash Debnath