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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

Create a master item measure from two other Master Items

Hi experts

I have two master items:

[item 1]:   if([Cap_D_W]='5' and [Flag]<>'X', sum(networkdays ([Date], [Date]))* [Cap_H_D], 0 )

[item 2]:  if([Cap_D_W]='5' and [Flag]='X', count([Date]) * [Difference of Time], 0)

Now I build a master item 3 measure:  [item 3]=[item 1] + [item 2]

The result on top of the table will NOT show the Total of all three items. I need the Total of [item 3] to calculate further on another master item [item 4]:

[item 4]= [item 3] / [item 5]

Any ideas how to solve this issue?

0 Replies