topic Re: set analysis issue in QlikView

set analysis issue

Tue, 05 Apr 2016 04:20:43 GMT

Hi experts,

i want to sum of values based on multiple conditions in expression below is my expression

sum({<eCRFFormName=P(m_FormName),PageMissing -={'0'},missing_CriticalForm={'Yes'}>} PageMissing)

eCRFFormName and m_FormName different fields from different tables, how to match different field values in set expression,Please give me your suggestion to modify the above expression

Regards,

Hari,

Re: set analysis issue

swuehl — Tue, 05 Apr 2016 17:11:22 GMT

How do these field values look like?

Re: set analysis issue

Kushal_Chawda — Tue, 05 Apr 2016 17:15:34 GMT

try this

sum({<eCRFFormName={"=eCRFFormName=m_FormName"},PageMissing -={'0'},missing_CriticalForm={'Yes'}>} PageMissing)

Re: set analysis issue

sunny_talwar — Tue, 05 Apr 2016 17:43:55 GMT

Can you share a sample? Difficult to know what you are trying to do, just by looking at an expression