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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ckiesling
Contributor II
Contributor II

Function Within Set Analysis

I am trying to get the value that is equal to the initial date minus the end date. How can you use subtraction within your set analysis? 

Sum({<[VitalSignset.Observation Unit Code]={'WE'}>}{1<[VitalSignset.Observation Value]=([VitalSignset.Create Date]-[VitalSignset.Observed Date]))

 

 

Labels (4)
1 Solution

Accepted Solutions
Gabbar
Specialist
Specialist

If you want to subract 1 measure from another,  Use: Measure_1 - Measure_2.

If you want to remove second set expression data from first and then use in measure 
then try 

only({<1st_set_expression,Field_name_2=e({<Second Set expression>})>}Field_name)

You can also use two dimension to calculae like

Only({<Set_expression>}Field_1 - Field_2)



View solution in original post

1 Reply
Gabbar
Specialist
Specialist

If you want to subract 1 measure from another,  Use: Measure_1 - Measure_2.

If you want to remove second set expression data from first and then use in measure 
then try 

only({<1st_set_expression,Field_name_2=e({<Second Set expression>})>}Field_name)

You can also use two dimension to calculae like

Only({<Set_expression>}Field_1 - Field_2)