Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

performing statistical analysis on data

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

2 Replies
MarcoWedel

How to identify numeric and character variable in data set?

try IsNum()

regards

Marco

maxgro
MVP
MVP

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.