Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How to identify numeric and character variable in data set?
try IsNum()
regards
Marco
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.