Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)