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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis

Hi ,

May i know that below expression is ok?. Because I used set analysis expression for workhour and travelhour and simple if condition for ContractedTime.

(Sum({< Audit_Date = {"<=$(#vDateTo)>=$(#vDateFrom)"}> } WorkHour)+Sum({< Audit_Date = {"<=$(#vDateTo)>=$(#vDateFrom)"}> } TravelHour))

/

(sum( if(Start_Time_Date >=Date_Master_From and Finish_Time_Date<=Date_Master_To,Contracted_Time)))

Can we use set analysis and if condition in one expression as above. Any suggestion appreciated.

1 Reply
Not applicable
Author

Requirement is same as mentioned, will it work or not correct please do let me know.