Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

Alt function

Hi,

What is the use of alt function? Give one example?

Thanks in Advance

11 Replies
renjithpl
Specialist
Specialist

Hi Jagan, 

My idea is to assign a 0 when there is a null, when we group it,
so this can be achieved just simply using Sum(Sales) as Sales 
When we use Sum(Sales) the null values are treated as 0 right. then why are we using alt(sum(sales),0) 

Does this alt function affects performance of the load when dealing with 25 millions of records 
Test:
Load,
ID,
Alt(sum(sales), 0) as Sales 
resident abc group by ID;

Regards
Renjith

 

Chanty4u
MVP
MVP

Hi,

i have created one doc regarding al function please have a look.

https://community.qlik.com/t5/Qlik-Sense-Documents/Multiple-Dates-Using-Alt/ta-p/1493744