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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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,

3 Replies
swuehl
MVP
MVP

How do these field values look like?

Kushal_Chawda

try this

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

sunny_talwar

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