Qlikview函数指南

目录

1 基本统计函数 10

1.1 SUM 函数...........................................................................................................................10

1.2 MIN 函数............................................................................................................................10

1.3 MAX 函数...........................................................................................................................11

1.4 Only 函数............................................................................................................................11

1.5 Mode 函数...........................................................................................................................11

1.6 firstsortedvalue 函数...........................................................................................................12

3.2 NumericCount 函数............................................................................................................14

3.3 TextCount 函数...................................................................................................................14

3.4 NullCount 函数...................................................................................................................15

3.5 MissingCount 函数.............................................................................................................15

4 统计函数 16

4.1 Avg 函数..............................................................................................................................16

4.2 stdev 函数............................................................................................................................16

4.3 median 函数........................................................................................................................16

4.4 fractile 函数.........................................................................................................................17

4.5 skew 函数............................................................................................................................17

4.12 linest_r2 函数....................................................................................................................19

4.13 linest_sem 函数.................................................................................................................20

4.14 linest_seb 函数..................................................................................................................20

4.15 linest_sey 函数..................................................................................................................20

5 财务统计函数 22

5.1 Irr 函数................................................................................................................................22

5.2 Xirr 函数.............................................................................................................................23

5.3 Npv 函数.............................................................................................................................24

5.4 Xnpv 函数...........................................................................................................................25

6 统计测试函数 26

6.6 TTest_sig 函数....................................................................................................................29

6.7 TTest_dif 函数.....................................................................................................................29

6.8 TTest_sterr 函数..................................................................................................................30

6.9 TTest_conf 函数..................................................................................................................30

6.10 TTest_lower 函数..............................................................................................................31

6.11 TTest_upper 函数..............................................................................................................31

6.12 TTestw_t 函数...................................................................................................................32

6.19 TTestw_upper 函数...........................................................................................................36

6.20 TTest1_t 函数....................................................................................................................36

6.21 TTest1_df 函数..................................................................................................................37

6.22 TTest1_sig 函数................................................................................................................37

6.23 TTest1_dif 函数.................................................................................................................38

6.24 TTest1_sterr 函数..............................................................................................................38

6.25 TTest1_conf 函数..............................................................................................................39

6.26 TTest1_lower 函数............................................................................................................39

6.27 TTest1_upper 函数............................................................................................................40

6.28 ZTest_sterr 函数................................................................................................................45

7 字段输入统计函数 48

7.1 Inputsum 函数.....................................................................................................................48

7.2 inputavg 函数......................................................................................................................49

8 高级统计函数 51

8.1 Aggr 函数............................................................................................................................51

9 集合分析 51

9.1 集合标志.............................................................................................................................52

9.2 集合运算.............................................................................................................................53

9.3 集合修改.............................................................................................................................54

9.4 带集合运算的集合修改.....................................................................................................55

10 虚拟纬度函数 58

10.1 ValueList 函数...................................................................................................................58

10.2 ValueLoop 函数.................................................................................................................58

11 基础算数函数 59

11.1 Div 函数............................................................................................................................59

11.2 mod 函数...........................................................................................................................59

11.3 fmod 函数..........................................................................................................................60

11.10 numsum 函数.................................................................................................................62

11.11 Numcount 函数..............................................................................................................62

11.12 Numavg 函数.................................................................................................................62

11.13 Nummin 函数.................................................................................................................62

11.14 Nummax 函数................................................................................................................62

11.15 Fact 函数........................................................................................................................63

11.16 combin 函数...................................................................................................................63

11.17 permut 函数....................................................................................................................63

11.18 even 函数........................................................................................................................63

11.19 odd 函数.........................................................................................................................64

12.5 Rangemax 函数.................................................................................................................66

12.6 Rangestdev 函数...............................................................................................................66

12.7 Rangeskew 函数................................................................................................................67

12.8 Rangekurtosis 函数...........................................................................................................67

12.9 Rangefractile 函数............................................................................................................67

12.10 Rangenumericcount 函数...............................................................................................68

12.11 Rangetextcount 函数.......................................................................................................68

12.12 Rangenullcount 函数......................................................................................................69

12.13 Rangemissingcount 函数...............................................................................................69

12.14 Rangemode 函数............................................................................................................70

12.20 rangenpv 函数................................................................................................................72

12.21 rangexirr 函数................................................................................................................73

12.22 rangexnpv 函数..............................................................................................................73

13 指数与对数函数 74

13.1 Exp 函数............................................................................................................................74

13.2 Log 函数............................................................................................................................74

13.3 log10 函数.........................................................................................................................74

14.3 Sin 函数.............................................................................................................................75

14.4 Asin 函数...........................................................................................................................76

14.5 Tan 函数............................................................................................................................76

14.6 Atan 函数...........................................................................................................................76

14.7 atan2 函数.........................................................................................................................76

14.8 Cosh 函数..........................................................................................................................76

14.9 Sinh 函数...........................................................................................................................76

14.10 Tanh 函数........................................................................................................................77

15 静态分布式函数 77

15.1 Chidist 函数......................................................................................................................77

15.8 finv 函数............................................................................................................................80

16 财务函数 80

16.1 BlackAndSchole 函数.......................................................................................................80

16.2 fv 函数...............................................................................................................................81

16.3 nper 函数...........................................................................................................................81

16.4 pmt 函数............................................................................................................................82

16.5 pv 函数..............................................................................................................................82

16.6 rate 函数............................................................................................................................83

17 算术常量函数 84

17.1 E 函数................................................................................................................................84

18.1 Ord 函数............................................................................................................................85

18.2 chr 函数.............................................................................................................................85

18.3 len 函数.............................................................................................................................85

18.4 Left 函数...........................................................................................................................85

18.5 right 函数...........................................................................................................................86

18.6 Mid 函数...........................................................................................................................86

18.7 index 函数.........................................................................................................................86

18.14 trim 函数........................................................................................................................88

18.15 KeepChar 函数................................................................................................................88

18.16 PurgeChar 函数...............................................................................................................89

18.17 Replace 函数...................................................................................................................89

18.18 subfield 函数..................................................................................................................89

18.19 info 函数..........................................................................................................................89

18.20 TextBetween 函数...........................................................................................................90

18.21 Findoneof 函数...............................................................................................................90

18.22 substringcount 函数.......................................................................................................90

18.23 applycodepage 函数.......................................................................................................91

19.6 Below 函数........................................................................................................................93

19.7 Top 函数............................................................................................................................94

19.8 Bottom 函数......................................................................................................................95

19.9 Before 函数.......................................................................................................................96

19.10 After 函数........................................................................................................................97

19.11 First 函数........................................................................................................................97

19.12 Last 函数........................................................................................................................98

19.13 RowNo 函数...................................................................................................................99

19.14 ColumnNo 函数............................................................................................................100

19.15 NoOfRows 函数...........................................................................................................100