topic Re: If Question in QlikView

If Question

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

Im using the expression as below

= If(PlantingMaterial='Socfindo',95) and its works

but i want to add, if other = 100

how to add the expression for that

total expression is if planting material is socfindo, score = 95, is planting material other than socfindo, score is 100

madhu_r — Thu, 24 Jan 2019 07:18:41 GMT

Hi,

Try this

= If(PlantingMaterial='Socfindo',95,If(PlantingMaterial='other',100))

Thanks & Regards,

Madhu

pasi_lehtinen — Thu, 24 Jan 2019 07:19:39 GMT

= If(
    PlantingMaterial='Socfindo',
    95,
    if(
        PlantingMaterial='Other',
        100
    )
)

pick(match(PlantingMaterial,'Socfindo','Other'),95,100)

iliaisyah — Thu, 24 Jan 2019 07:26:44 GMT

Thank you it works!

MindaugasBacius — Thu, 24 Jan 2019 08:01:05 GMT

iliaisyah don't for get to close the thread by checking the correct answer.
Thank you!

sergio0592 — Thu, 24 Jan 2019 20:00:36 GMT

Otherwise, you can use this syntax :

=pick(match(PlantingMaterial,'Socfindo')+1,100,95)

Here advantage is that it works even if you don't have 'other' value in your data.

iliaisyah — Tue, 26 Feb 2019 08:52:48 GMT

This also works!