topic Re: Firstsorted value issue in QlikView

Firstsorted value issue

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

When i change the period sort filter, the text box not showing the previous value

attached example

can any one help?

Re: Firstsorted value issue

gauthamchilled — Mon, 15 Oct 2018 04:57:31 GMT

Bump

Re: Firstsorted value issue

tresB — Mon, 15 Oct 2018 05:14:03 GMT

If it is related to: Current Vs PRevious

Try :

=Max({<Period_Sort={"<$(=Max(Period_Sort))"}>}Period_Sort)

Re: Firstsorted value issue

jyothish8807 — Mon, 15 Oct 2018 06:09:47 GMT

Hi Tresesesco,

Nice solution , can you please help me to understand how it takes only the previous value ?

If i make it '>' it always takes the max value .

Br,

Re: Firstsorted value issue

jyothish8807 — Mon, 15 Oct 2018 06:15:41 GMT

Hi Gautha,

One more approach.

Load * inline

[

Period_Sort, Order

20171, 1

20172, 2

20181, 3

20182, 4

]

Create a variable :

Var=concat( {1}chr(39)&Period_Sort&chr(39),',')

In text box:

=pick(MaxString({$<Order=>}Order)-1,$(Var))

Br,

Re: Firstsorted value issue

shreya_nadkarni — Mon, 15 Oct 2018 06:16:13 GMT

superb solution!

Re: Firstsorted value issue

tresB — Mon, 15 Oct 2018 06:42:32 GMT

Period_Sort={"<$(=Max(Period_Sort))"} - gives all values less than the maximum (in scope). Therefore, if you select 20181, the possible values to Max() would be 20171, 20172, and max() would then return 20172 which is second to the selected one/max in the scope.

Re: Firstsorted value issue

jyothish8807 — Mon, 15 Oct 2018 07:20:36 GMT

Nice , Thanks for the explanation.

Br,