Set analysis

[Luffy20]

Hi all,

I have a data as below

Country	Fuel	Fuel_Liters	No of Vechicles
Estonia	Diesel		15
Italy	Petrol		20
Latvia	Diesel	20	13
Lithuania	Petrol		30
Poland	Diesel		26
Poland	Petrol	2	626
Russia	Diesel		380
Belarus	Diesel		122
Estonia	Diesel	35	15
Estonia	Diesel	39	159
Denmark	Petrol	44	11

I want to get the expression like if we have Null (Or spaces) in Fuel_Litres column we should get no of vechicles count in Fuel_litres column or else we should use the numbers in Fuel_litres. As i am new to this qlik ,i got stuck here ,can i get your help.

[PrashantSangle · Accepted solution]

in script only, you can write, 

if(len(trim(Fuel_Liters))>0,Fuel_Liters,no of vechicles) as new_Fuel_Liters

use this field in your expression.

Regards,

Prashant Sangle