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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

including if condition in set analysis

Hi

Can anybody please help me with writing these expressions:

I need to include the condition : if(DAY_DATE >= '$(From)' and DAY_DATE <= '$(To)'

in below expressions:

=sum({<OPERATION_NAME*={'PRODUCTION'}>} USED_HOURS) / sum(AVAILABLE_HOURS)

=sum({<HOUR_SEG_PRIME*={'AM-OS:12 AM - 7 AM'}>}USED_HOURS)

=sum(USED_HOURS)/Sum (Total <TESTER> AVAILABLE_HOURS)

Thanks

0 Replies