topic IF Statement in QlikView

IF Statement

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

Hi,

I have the following variables:

I would like to create an expression in a straight table that says something like the following:

If Group=Fuel Oil then vFuelOil*(an expression I have created) or

If Group=Gasoline then vGasoline*(same expression as the above) or

If Group=MidDist then vMidDist*(same expression as the above)

else 0

Is the above possible?

Thanks,

Daniel

Anil_Babu_Samineni — Fri, 18 Nov 2016 11:02:21 GMT

Yes, I think we can. but, Can we have the expression

Anonymous — Fri, 18 Nov 2016 11:08:16 GMT

if(Group = 'Fuel', vFuelOil * [expression],

if(Group = 'Gasoline', vGasoline * [expression],

if(Group = 'MidDist', vMidDist * [expression])))

varshavig12 — Fri, 18 Nov 2016 11:51:50 GMT

=if(Group = 'Fuel', vFuelOil * [expression],

if(Group = 'Gasoline', vGasoline * [expression],

if(Group = 'MidDist', vMidDist * [expression] ,0 )))

danielnevitt — Fri, 18 Nov 2016 12:05:49 GMT

Marcio/Varsha,

Thank you both for your help.

Regards,

Daniel

sunny_talwar — Fri, 18 Nov 2016 12:12:48 GMT

Just as a way for slight improvement, you can use Pick(Match()) here

Pick(Match(Group, 'Fuel' , 'Gasoline', 'MidDist'),

vFuelOil ,

vGasoline,

vMidDist) * expression