Documents for Qlik Sense related information.
Hi all ,
In that attached excel file material4 coloumn 'TAB' and 'SMP' needs to show 'REL' coloumn for that i need script any one help me for that.
Try this insert into your load script:
,if(material4='TAB' or material4='SMP',REL,material4) as ColumnNameYouWant
i tried but i am getting this error Field not found - <REL>
if([Material Group Desc.]=material,'REL', if([Distribution Channel]=81,'SMB', if([Distribution Channel]=11,'CON',[Material Group Desc.])))as REL4,
if(material4='TAB' or material4='SMP',REL,material4) as ColumnName
The shared excel contains this column,
your script is based on tab2. doesn't tab2 contain REL column?
no my quaation is material4 coloumn data i.e, SMP and TAB to reflect REL coloumn .
Could you share with as an example qvf?