Alt Function In qlikview

[rupaliqlik]

Hi Team,

There is one code in existing dashboard which is developed by someone else.I just wanted to know how to read this.I am not understanding this one.

Alt(IF(MATCH([Plant - Internal Inventory],'1012','1013','3113','E131','E132','E121'), Alt([#Net Unrestricted Inventory],0) + Alt([#Stock in Transit],0), 0),0)
+ Alt(IF(MATCH([Plant - Internal Inventory],'1003','1022','A516','A514'), Alt([#Stock Unrestricted Use Value],0)),0) AS [#Total Inventory_tmp]

#Alt Function

@abhijitnalekar 

Thanks,

[Qrishna]

The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. 

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/Conditi...