topic performing statistical analysis on data in QlikView

performing statistical analysis on data

Wed, 09 Dec 2015 07:15:29 GMT

I have a requirement to create dashboard for performing statistical analysis on data fields.

It should be generic dashboard where we can plug in any data and should be able to perform following operations

without much manual effort.

for ex. for numeric variable

1. Min

2. Max

3. Median

4. Std Dev

5. Mode

6. Coefficient of variance

7. 25th percentile and 75th percentile

8. missing data %

for character variable

1. mode

2. unique string

3. missing data %

4. second highest value (in terms of frequency)

How to identify numeric and character variable in data set?

Mode of variable returns Null in case of two values having same number of occurrence, how to deal with it.

Thanks in advance

Re: performing statistical analysis on data

MarcoWedel — Sat, 12 Dec 2015 21:22:04 GMT

‌How to identify numeric and character variable in data set?

try IsNum()

regards

Marco

Re: performing statistical analysis on data

maxgro — Sun, 13 Dec 2015 08:53:10 GMT

Mode of variable returns Null in case of two values having same number of occurrence, how to deal with it.

the expression could be

alt(Mode(yourfield), 'something instead of null.....')

From Qlik help

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.