topic Re: Alt function in QlikView

Alt function

prabhas277 — Mon, 16 Mar 2015 05:22:32 GMT

Hi,

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

Thanks in Advance

Re: Alt function

avinashelite — Mon, 16 Mar 2015 05:24:20 GMT

Hi,

Please refer this:

alt(case1[ , case2 , case3 , ...] , else)

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. Any number of parameters can be used.

Example:

alt( date#( dat , 'YYYY/MM/DD' ),

date#( dat , 'MM/DD/YYYY' ),

date#( dat , 'MM/DD/YY' ),

'No valid date' )

Will test if the field date contains a date according to any of the three specified date formats. If so, it will return the original string and a valid number representation of a date. If no match is found, the text 'No valid date' will be returned (without any valid number representation).

Re: Alt function

aveeeeeee7en — Mon, 16 Mar 2015 05:34:05 GMT

Go through the below posts:

http://qlikshare.com/using-alt-function-qlikview/

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/25/which-conditional-functions-do-you-use

Regards

Av7eN

Re: Alt function

robert_mika — Mon, 16 Mar 2015 05:40:21 GMT

Alt belongs to Conditional function (like extended IF function) returning first numerical value.

In this case 1 is returned

in this 2

and so on..

If no number is found the last value is returned:

Re: Alt function

Mon, 16 Mar 2015 10:12:58 GMT

Hi @prabhas v

Check this THREAD below

Which conditional functions do you use?

In this Thread Use of ALT Function is Explained in detail check this

Thanks & Regards

Re: Alt function

jagan — Mon, 16 Mar 2015 10:26:16 GMT

Hi,

It is similar to NVL() in Oracle, ISNULL() in SQL Server.

If the first parameter returns null then the second parameter value is assigned.

Alt(Sum(Sales), 0)

If Sum(Sales) is null then 0 is returned

Alt(Only(Year), Year(Today())) - If Only(Year) returned null then Current year is assigned to it.

Also you can multiple levels in this which is similar If-elseif-else or Case statement

alt( date#( dat , 'YYYY/MM/DD' ),

date#( dat , 'MM/DD/YYYY' ),

date#( dat , 'MM/DD/YY' ),

'No valid date' )

Regards,

Jagan.

Re: Alt function

Mon, 29 Feb 2016 12:52:42 GMT

Hi Robert,

I have a scenario that i need to convert the if condition expression into Alt finction

if(IF(GetFieldSelections(Earlypayment) = 'NEFT' AND Payment_Discount<>0 ,1,0)=1, Discountperday * PaymentFunds ,0)

I tried like this,

=Alt(IF(GetFieldSelections(Earlypayment) = 'NEFT' AND Payment_Discount<>0 ,1,0)=1, Discountperday * PaymentFunds ,0)

Re: Alt function

Chanty4u — Mon, 29 Feb 2016 12:54:25 GMT

chk dis

Alt Function

Re: Alt function

Anil_Babu_Samineni — Fri, 24 Jun 2016 08:25:30 GMT

Nice Explanation...

I like this

Re: Alt function

chiranjeevialapati — Thu, 05 Mar 2020 10:56:51 GMT

Very Nice Explanation.

Re: Alt function

renjithpl — Wed, 14 Oct 2020 09:39:30 GMT

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

Re: Alt function

Chanty4u — Wed, 14 Oct 2020 09:43:05 GMT

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