Discussion board where members can get started with Qlik Sense.
I have below table.
Flight stop type Origin Stop place Destinatiom
I want create a new field Flight Destination from the Existing fields. If Stop Point=1, I want Flight Destination= Destination Field records,
or stoptype= CNX, i want Flight destination= Stop place filed records. I want output records like...
Flight Destination (NEW COLUMN)
Do you want to do this in the load script or in the front end?
try Below If Condition.
if( [stop type]=1,Destination,if([stop type]='CNX', [Stop place]) ) as NewField;
find the attached App
PFA attached Sample
Try this in your script
If([ stop type]=1,[Destinatiom],[Stop place]) as [Flight Destination]