6 Replies Latest reply: Jul 8, 2015 5:31 AM by sivasankar kanagasabai RSS

    diff functions

      hi can u say tell me diff types of

       

       

      UI FUNCTIONS and  script level functions

      thanks

        • Re: diff functions
          sindhu kannan

          Refer the below link.

           

          Qlikview Functions

          • Re: diff functions
            Pradip Sen

            Do you want this?

             

            Basic Aggregation Functions:

            ----------------------------

            sum()

            min()

            max()

            only()

            mode()

            firstsortedvalue ([ distinct ] expression [, sort-weight [, n ]])

             

             

            String Aggregation Functions:

            -----------------------------

            MinString()

            MaxString()

            FirstValue(expression)

            LastValue(expression)

            concat ([ distinct ] expression [, delimiter [, sort-weight]])

             

            Counter Aggregation Functions:

            -------------------------------

            count([distinct ] expression | * )

            NumericCount([ distinct ] expression )

            TextCount([ distinct ] expression)

            NullCount([ distinct ] expression )

            MissingCount([ distinct ] expression )

             

             

            Advanced Aggregation

            --------------------

            aggr ([ distinct | nodistinct ] [{set_expression}]expression {,dimension})

             

            Statistical Aggregation Functions in Script:

            -------------------------------------------

            fractile(expression, fractile)

            fractile( Grade, 0.75 )

            kurtosis([distinct ] expression )

            correl(x-expression, y-expression)

            avg([distinct] expression)

            stdev([distinct] expression)

            skew([ distinct] expression)

            median (expression)

            sterr ([distinct] expression)

            steyx (y-expression, x-expression)

            linest_m (y-expression, x-expression [, y0 [, x0 ]])

            linest_b (y-expression, x-expression [, y0 [, x0 ]])

            linest_r2 (y-expression, x-expression [, y0 [, x0 ]])

            linest_sem (y-expression, x-expression [, y0 [, x0 ]])

            linest_seb (y-expression, x-expression [, y0 [, x0 ]])

            linest_sey (y-expression, x-expression [, y0 [, x0 ]])

            linest_df (y-expression, x-expression [, y0 [, x0 ]])

            linest_ssreg (y-expression, x-expression [, y0 [, x0 ]])

            linest_f (y-expression, x-expression [, y0 [, x0 ]])

            linest_ssresid (y-expression, x-expression [, y0 [, x0 ]])

             

             

             

             

            Financial Aggregation Functions in Script:

            ------------------------------------------

             

             

            irr(expression)

            xirr (valueexpression, dateexpression )

            npv (rate, expression)

            xnpv (rate, valueexpression, dateexpression)

             

             

             

             

            Statistical Test Functions in Script:

            ------------------------------------

             

             

             

             

            chi2test_p (col, row, observed_value [, expected_value])

            chi2test_df (col, row, observed_value [, expected_value])

            chi2test_chi2 (col, row, observed_value [, expected_value])

            TTest_t (group, value [, eq_var = true])

            TTest_df (group, value [, eq_var = true])

            TTest_sig (group, value [, eq_var = true])

            TTest_dif (group, value [, eq_var = true])

            TTest_sterr (group, value [, eq_var = true])

            TTest_conf (group, value [, sig = 0.025 [, eq_var = true]])

            TTest_lower (group, value [, sig = 0.025 [, eq_var = true]])

            TTest_upper (group, value [, sig = 0.025 [, eq_var = true]])

            TTestw_t (weight, group, value [, eq_var = true])

            TTestw_df (weight, group, value [, eq_var = true])

            TTestw_sig (weight, group, value [, eq_var = true])

            TTestw_dif (weight, group, value [, eq_var = true])

            TTestw_sterr (weight, group, value [, eq_var = true])

            TTestw_conf (weight, group, value [, sig = 0.025 [, eq_var =true]])

            TTestw_lower (weight, group, value [, sig = 0.025 [, eq_var =true]])

            TTestw_upper (weight, group, value [, sig = 0.025 [, eq_var =true]])

            TTest1_t (value)

            TTest1_df (value)

            TTest1_sig (value)

            TTest1_dif (value)

            TTest1_sterr (value)

            TTest1_conf (value [, sig = 0.025 ])

            TTest1_lower (value [, sig = 0.025 ])

            TTest1_upper (value [, sig = 0.025 ])

            TTest1w_t (weight, value)

            TTest1w_df (weight, value)

            TTest1w_sig (weight, value)

            TTest1w_dif (weight, value)

            TTest1w_sterr (weight, value)

            TTest1w_conf ( weight, value [, sig = 0.025 ])

            TTest1w_lower (weight, value [, sig = 0.025 ])

            TTest1w_upper (weight, value [, sig = 0.025 ])

            ZTest_z (value [, sigma])

            ZTest_sig (value [, sigma])

            ZTest_dif (value [, sigma])

            ZTest_sterr (value [, sigma] )

            ZTest_conf (value [, sigma [, sig = 0.025 ])

            ZTestw_z (weight, value [, sigma])

            ZTestw_sig (weight, value [, sigma])

            ZTestw_sterr (weight, value [, sigma])

             

             

             

             

            Chart General Numeric Functions:

            --------------------------------

             

             

            div(x1 , x2)

            mod(x1 , x2)

            fmod(x1 , x2)

            ceil(x [ , base [ , offset ]])

            floor(x [ , base [ , offset ]])

            frac(x)

            round( x [ , base [ , offset ]])

            fabs(x)

            numsum( expr1 [ , expr2, ... exprN ])

            numcount(expr1 [ , expr2, ... exprN ])

            numavg(expr1 [ , expr2, ... exprN ])

            nummin(expr1 [ , expr2, ... exprN ])

            nummax(expr1 [ , expr2, ... exprN ])

            fact(n)

            combin(n1, n2)

            permut(n1, n2)

            even(n)

            odd(n)

            sign(x)

            bitcount(i )

             

             

             

             

            Chart Range Functions:

            ----------------------

             

             

            rangesum(expr1 [ , expr2, ... exprN ])

            rangeavg(expr1 [ , expr2, ... exprN ])

            rangecount(expr1 [ , expr2, ... exprN ] )

            rangemin(expr1 [ , expr2, ... exprN ])

            rangemax(expr1 [ , expr2, ... exprN ])

            rangestdev(expr1 [ , expr2, ... exprN ])

            rangeskew(expr1 [ , expr2, ... exprN ])

            rangekurtosis(expr1 [ , expr2, ... exprN ])

            rangefractile(fractile ,expr1 [ , expr2, ... exprN ])

            rangenumericcount(expr1 [ , expr2, ... exprN ])

            rangetextcount(expr1 [ , expr2, ... exprN ])

            rangenullcount(expr1 [ , expr2, ... exprN ])

            rangemissingcount(expr1 [ , expr2, ... exprN ])

            rangeminstring(expr1 [ , expr2, ... exprN ])

            rangemaxstring(expr1 [ , expr2, ... exprN ])

            rangemode(expr1 [ , expr2, ... exprN ])

            rangeonly(expr1 [ , expr2, ... exprN ])

            rangecorrel(x-value , y-value { , x-value , y-value})

            rangeirr(value { ,value} )

            rangenpv (rate, value { ,value} )

            rangexirr(value, date { ,value, date} )

            rangexnpv(rate, value, date { ,value, date} )

             

             

             

             

             

             

            Exponential and Logarithmic Functions:

            -------------------------------------

            exp(x )

            log(x )

            log10(x )

            sqrt(x )

            sqr (x )

            pow(x,y )

             

             

             

             

             

             

            Trigonometric and Hyperbolic Functions:

            ----------------------------------------

             

             

            cos( x )

            acos(x )

            sin(x )

            asin(x )

            tan( x )

            atan(x )

            atan2( y,x )

            cosh(x )

            sinh(x )

            tanh(x )

             

             

             

             

             

             

            Statistical Distribution Functions:

            -----------------------------------

             

             

            chidist (value, degrees_freedom)

            chiinv (prob, degrees_freedom)

            normdist (value, mean, standard_dev)

            norminv (prob, mean, standard_dev)

            tdist (value, degrees_freedom, tails)

            tinv (prob, degrees_freedom)

            fdist (value, degrees_freedom1, degrees_freedom2)

            finv (prob, degrees_freedom1, degrees_freedom2)

             

             

             

             

            Financial Functions:

            --------------------

             

             

            fv(rate, nper, pmt [ ,pv [ , type ] ])

            nper(rate, pmt, pv [ ,fv [ , type ] ])

            pmt(rate, nper, pv [ ,fv [ , type ] ] )

            pv(rate, nper, pmt [ ,fv [ , type ] ])

            rate(nper, pmt , pv [ ,fv [ , type ] ])

             

             

             

             

            Black and Schole:

            -----------------

             

             

             

             

            BlackAndSchole(strike , time_left , underlying_price , vol , risk_free_rate , type)

             

             

             

             

            Mathematical Constants and Parameter-Free Functions:

            ----------------------------------------------------

             

             

             

             

            e( )

            pi( )

            rand( )

            true( )

            false( )

             

             

             

             

            Counter Functions:

            ------------------

             

             

            RecNo( )

            RowNo( )

            autonumber(expression[ , AutoID])

            autonumberhash128(expression {, expression})

            autonumberhash256(expression {, expression})

            fieldvaluecount(fieldname)

             

             

             

             

            String Functions

            ----------------

             

             

            ord( s )

            chr( n )

            len( s )

            left( s , n )

            right( s , n )

            mid(s, n1[, n2 ])

            index(s1 , s2[ , n])

            upper(textexpression)

            lower( textexpression )

            repeat( s, n)

            subfield(s, 'delimiter' [ , index ] )

            ltrim(s )

            rtrim(s )

            trim(s )

            KeepChar(s1 , s2)

            PurgeChar(s1, s2)

            capitalize(s )

            evaluate(s )

            TextBetween(s , beforetext , aftertext [, n ])

            Replace(s, fromstring ,tostring)

            FindOneOf(text , characterset [ , n])

            hash256(expression {, expression} )

            hash160(expression {, expression})

            hash128(expression {, expression})

             

             

            Mapping Functions:

            ------------------

             

             

            applymap('mapname', expr [ , defaultexpr ] )

            mapsubstring('mapname', expr)

             

             

             

             

            Inter Record Functions:

            ------------------------

             

             

             

             

            exists(field [ , expression ])

            previous(expression )

            peek(fieldname [ , row [ , tablename ] ] )

            FieldValue(fieldname , n )

            FieldIndex(fieldname , value )

            lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])

             

             

            Conditional Functions:

            -----------------------

             

             

            if(condition , then , else)

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

            pick(n, expr1[ , expr2,...exprN])

            match( str, expr1 [ , expr2,...exprN ] )

            mixmatch( str, expr1 [ , expr2,...exprN ] )

            wildmatch( str, expr1 [ , expr2,...exprN ] )

            class(expression, interval [ , label [ , offset ]])

             

             

            Logical Functions:

            -----------------

             

             

            IsNum( expr)

            IsText(expr)

            IsPartialReload( )

             

             

             

             

            NULL Functions:

            ----------------

             

             

            Null( )

            IsNull(expr )

             

             

             

             

            System Functions:

            ----------------

             

             

            ClientPlatform( )

            OSuser( )

            QVuser( )

            ComputerName( )

            ReloadTime( )

            GetActiveSheetID()

            GetCurrentField(groupname)

            GetCurrentSelections([ recordsep [, tagsep [, valuesep [, maxvalues=6 ]]]])

            GetFieldSelections(fieldname [, valuesep [, maxvalues=6 ]])

            GetSelectedCount(fieldname [, includeexcluded=false])

            GetPossibleCount(fieldname)

            GetExcludedCount(fieldname)

            GetAlternativeCount(fieldname)

            GetNotSelectedCount(fieldname [, includeexcluded=false])

            GetRegistryString(path, key)

            qlikviewversion()

            MsgBox(str msg [, str caption [, mb_buttons [, mb_icons[, mb_defbutton]]]])

            Input(str cue [, str caption])

            DocumentName( )

            DocumentPath( )

            DocumentTitle( )

            GetObjectField ([index])

            GetExtendedProperty (name[, objectid])

             

             

             

             

            File Functions in Script:

            -------------------------

             

             

            Attribute(filename, attributename)

            ConnectString()

            filebasename()

            filedir()

            fileextension()

            filename()

            filepath()

            filesize()

            filetime([ filename ])

            GetFolderPath()

            QvdCreateTime(filename)

            QvdNoOfRecords(filename)

            QvdNoOfFields(filename)

            QvdFieldName(filename , fieldno)

            QvdTableName(filename)

             

             

             

             

            Table Functions:

            ---------------

             

             

             

             

            FieldName(nr ,'TableName')

            FieldNumber('field ' ,'TableName')

            NoOfFields([ 'TableName ' ])

            NoOfRows(['TableName ' ])

            NoOfTables()

            TableName([ 'TableNumber' ])

            TableNumber([ 'TableName' ])

             

             

             

             

            Document Functions:

            ------------------

             

             

            ReportComment(report_number)

            ReportName(report_number)

            ReportID(report_number)

            ReportNumber(report_id_or_name)

            NoOfReports()

             

             

             

             

            Date and Time Functions:

            -----------------------

             

             

            second(expr)

            minute(expr)

            hour(expr)

            day(date)

            week(date)

            month(date)

            year(date)

            weekyear(date)

            weekday(date)

            now([ timer_mode])today([timer_mode] )

            LocalTime([timezone [, ignoreDST ]])

            MakeDate(YYYY [ , MM [ , DD ] ] )

            MakeWeekDate(YYYY [ , WW [ , D ] ] )

            MakeTime(hh [ , mm [ , ss [ .fff ] ] ] )

            AddMonths(startdate, n , [ , mode] )

            YearToDate(date [ , yearoffset [ , firstmonth [ , todaydate] ] ])

            TimeZone( )

            GMT( )

            UTC( )

            DaylightSaving( )

            SetDateYear (timestamp, year)

            SetDateYearMonth (timestamp, year, month)

            InYear (date, basedate , shift [, first_month_of_year = 1])

            InYearToDate (date, basedate , shift [, first_month_of_year = 1])

            InQuarter (date, basedate , shift [, first_month_of_year = 1])

            InQuarterToDate (date, basedate , shift [, first_month_of_year =1])

            InMonth (date, basedate , shift)

            InMonthToDate (date, basedate , shift)

            InMonths (n, date, basedate , shift [, first_month_of_year = 1])

            InMonthsToDate (n, date, basedate , shift [, first_month_of_year =1])

            InWeek (date, basedate , shift [, weekstart])

            InWeekToDate (date, basedate , shift [, weekstart])

            InLunarWeek (date, basedate , shift [, weekstart])

            InLunarWeekToDate (date, basedate , shift [, weekstart])

            InDay (timestamp, basetimestamp , shift [, daystart])

            InDayToTime (timestamp, basetimestamp , shift [, daystart])

            YearStart( date [, shift = 0 [, first_month_of_year = 1]])

            YearEnd( date [, shift = 0 [, first_month_of_year = 1]])

             

             

             

             

            Number Interpretation Variables:

            -------------------------------

             

             

            ThousandSep

            DecimalSep

            MoneyThousandSep

            MoneyDecimalSep

            MoneyFormat

            TimeFormat

            DateFormat

            TimestampFormat

            MonthNames

            LongMonthNames

            DayNames

            LongDayNames

             

             

             

             

            Formatting Functions:

            ---------------------

             

             

             

             

            num(expression [ , format-code [ , decimal-sep [ , thousands-sep ]

            money(expression [ , format-code [ , decimal-sep [ , thousands-sep] ] ])

            date(expression [ , format-code ])

             

             

            time(expression [ , format-code ])

             

             

            dual( s , x )

             

             

            interval(expression [ , format-code ])

             

             

            timestamp(expression [ , format-code ])

             

             

             

             

            Color Functions:

            -----------------

             

             

            color (n)

            RGB (e1, e2, e3 )

            ARGB(alpha, e1, e2, e3)

            HSL (hue, saturation, luminosity)

            black( )

            darkgray( )

            lightgray( )

            white( )

            blue( )

            lightblue( )

            green( )

            lightgreen( )

            cyan( )

            lightcyan( )

            red( )

            lightred( )

            magenta( )

            lightmagenta( )

            brown( )

            yellow( )

            qliktechgray( )

            Colormix1(Value , ColorZero , ColorOne)

            syscolor(nr)

            qliktechblue( )

            • Re: diff functions
              Andrew Whitfield

              HI Naveen,

               

              all of listed may be found in the QV Help

               

              HTH - Andy

              • Re: diff functions
                Avinash R

                Hi Naveen,

                 

                Refer Qlikview help and Qlikview reference manual those are the best source

                • Re: diff functions
                  jagan mohan rao appala

                  Hi,

                   

                  Refer Qlikview Reference Manual for details and example of all functions.  The below some of the function types available in Qlikview

                   

                  • Ø String Functions
                  • Ø Math Functions
                  • Ø Aggregation Functions
                  • Ø Conditional Functions
                  • Ø Color Functions
                  • Ø Date and Time Functions
                  • Ø Counter Functions
                  • Ø Exponential and Logarithmic Functions
                  • Ø Formatting Functions
                  • Ø General Numeric Functions
                  • Ø Inter record Functions
                  • Ø Logical Functions
                  • Ø Mapping Functions
                  • Ø Number Interpretation Functions
                  • Ø Ranking Functions
                  • Ø Range Functions
                  • Ø System Functions
                  • Ø Table Functions
                  • Ø File Functions

                   

                  Regards,

                  Jagan.

                  • Re: diff functions
                    sivasankar kanagasabai

                    Naveen,

                    Qlikview has 359 functions:

                                              1. Front End (UI) and

                                                2. Back End(Script)

                    They are grouped into 23 categories:

                     

                    Inter-record
                    Trigonometric and Hyperbolic
                    Date & Time
                    None
                    Conditional
                    String
                    Mapping
                    Color
                    System
                    Counter Functions
                    Aggregation
                    General Numeric
                    Financial
                    Formating
                    Number Interpretation
                    Mathematical constatns and Parameter free Functions
                    Exponential and Logarithmic
                    Rank
                    Null
                    Logical
                    Range
                    File
                    Table