Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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