topic Re: Only with If statement in QlikView

Only with If statement

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Can any one tell me the function of only ? and what does this function is doing in below expression

ONLY({<Well.Name=>}IF(Well.Name='HW08',TW_SP_BO.Reservoir_Pressure))

if i am removing ONLY({<Well.Name=>} then expression is giving me null values.

Please help

Regards

Manu

Anil_Babu_Samineni — Wed, 21 Mar 2018 16:38:01 GMT

This should work, Even if you remove Only() and Degrade Field? Aren't you?

IF(Well.Name='HW08',[TW_SP_BO.Reservoir_Pressure])

sunny_talwar — Wed, 21 Mar 2018 16:40:46 GMT

I think the only purpose here is to be able to use set analysis here... have you made a selection in Well.Name field when it turns to null?

olivierrobin — Wed, 21 Mar 2018 16:40:55 GMT

hello

extract from help

Only() returns a value if there is one and only one possible result from the aggregated data. If the records

so if it returns null, it is because theri is more that one value in Well.Name

manu1512 — Wed, 21 Mar 2018 16:45:26 GMT

Thanks sunny its works after selecting welll name