Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: performing statistical analysis on data

How to identify numeric and character variable in data set?

try IsNum()

regards

Marco

MVP
MVP

Re: performing statistical analysis on data

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.

Community Browser