-
Re: TOP N LOAD * INLINE
Arvind Patil Jul 26, 2017 9:29 AM (in response to Michael Ostrovsky)HI Michael,
please Find attachment It will help you.
Just modify Variable value to your Inline table value.
Thanks,
Arvind Patil
-
Re: TOP N LOAD * INLINE
Michael Ostrovsky Jul 26, 2017 9:36 AM (in response to Arvind Patil)May be i didn't looked at the right place... found only variable and id.. not the expration
but thank u!
-
-
Re: TOP N LOAD * INLINE
Piet Hein van der Stigchel Jul 26, 2017 9:30 AM (in response to Michael Ostrovsky)Try with
=Alt(TopValues,Count(DimensionField))
-
Re: TOP N LOAD * INLINE
Michael Ostrovsky Jul 26, 2017 9:37 AM (in response to Piet Hein van der Stigchel )Thank you very much!! It working!
Alt is Alternative?
-
Re: TOP N LOAD * INLINE
Piet Hein van der Stigchel Jul 26, 2017 10:02 AM (in response to Michael Ostrovsky)You're welcome. From the help
alt - script and chart function
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.
Syntax:
alt(case1[ , case2 , case3 , ...] , else)
The alt function is often used with number or date interpretation functions. This way, QlikView can test different date formats in a prioritized order. It can also be used to handle NULL values in numerical expressions.
-
Re: TOP N LOAD * INLINE
Michael Ostrovsky Jul 26, 2017 10:19 AM (in response to Piet Hein van der Stigchel )Thank you very much!
-
-
-
-
Re: TOP N LOAD * INLINE
Andrey Khoronenko Jul 26, 2017 9:33 AM (in response to Michael Ostrovsky)Hi,
Which object Qlik Sense are you using for selection of TopValues?
-
Re: TOP N LOAD * INLINE
Michael Ostrovsky Jul 26, 2017 9:37 AM (in response to Andrey Khoronenko)Field UI
-