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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis issue

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,

Labels (1)
3 Replies
swuehl
Champion III
Champion III

How do these field values look like?

Kushal_Chawda
MVP
MVP

try this

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

sunny_talwar
MVP
MVP

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