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: 
zuberahmed
Contributor
Contributor

Issue with If Condition in Master Measure ?

Hi Folks , Greeting for the day , 

I am new to qlik trying to find Avg of Waiting Time Packaging for which logics goes as 

"Packaging Waiting Time – If coating is zero (Packaging start minus Compression end) OR (Packaging Start minus coating end)"

I am getting for two line items i.e. M & N block right however getting wrong for rest

zuberahmed_0-1663248406810.png

This is what i am getting 

zuberahmed_1-1663248448115.png

This is what expected 

My Formula for calculation Packaging Waiting Time is created in Master Measure

zuberahmed_2-1663248563020.png

Please Suggest me how could i get to my desired result !!

I Have also attached Excel as base data for consideration

Thanks in Advance 

Labels (2)
1 Reply
martinpohl
Partner - Master
Partner - Master

Hi,

i think you should calculate the value from your expression in your datas as a new field.

then you can exclude invalid combintions of filled fields also.

Regards