topic Re: FirstSortedValue Expression issue in QlikView

FirstSortedValue Expression issue

techvarun — Wed, 03 Oct 2018 07:26:56 GMT

Hi Experts,

The Below Expression is not evaluating the FirstSortedValue Statement.

=sum({1< [Source System] ={DLDAU}, [A Process Date]={"=FirstSortedValue({<[A Process Date]={'<=$(=Max([A Process Date]))'},_Day=,_Month=, _Year=>} TOTAL <[Source System]> [Process Date], -[Process Date])"}>}[B Job SuccessCNT])

Please help me to fix.

Thanks a lot in advance.

Re: FirstSortedValue Expression issue

tresB — Wed, 03 Oct 2018 07:35:04 GMT

A quick fix try:

[A Process Date]={'$(=FirstSortedValue({<[A Process Date]={'<=$(=Max([A Process Date]))'}_Day=,_Month=, _Year=>} TOTAL <[Source System]> [Process Date], -[Process Date]))'}

If this doesn't work, try to share a sample app.

Re: FirstSortedValue Expression issue

techvarun — Wed, 03 Oct 2018 12:54:43 GMT

Thanks tresesco‌ for the prompt reply, However I am yet to get the desired result.

Kindly refer the attached app.

For the selection of Sep 18 currently i am getting the below result

Core Source System	date	Sum
123	2018-09-27	0
225	2018-09-28	12

And my expected result is

Core Source System	date	Sum
123	2018-09-27	12
225	2018-09-28	12

Where as the Sum for 123 should come from Sep 27.

Thanks a lot in advance

Re: FirstSortedValue Expression issue

techvarun — Thu, 04 Oct 2018 04:36:53 GMT

Hi experts,

Any Inputs?

Re: FirstSortedValue Expression issue

tresB — Thu, 04 Oct 2018 06:33:48 GMT

Try:

FirstSortedValue({<Core_Day=,Core_Month=, Core_Year>} Aggr( NODISTINCT Sum({<Core_Day=,Core_Month=, Core_Year>} [CoreB Job SuccessCNT]),[Core Source System],[Core Process Date]), -[Core Process Date])

Re: FirstSortedValue Expression issue

techvarun — Thu, 04 Oct 2018 06:38:55 GMT

Thanks Tresesco

This works like a charm, I have another query what if i need to Display the Sum (24 in this case) in a text box?

Please help me with that

Re: FirstSortedValue Expression issue

tresB — Thu, 04 Oct 2018 06:43:54 GMT

=Sum({<Core_Day=,Core_Month=, Core_Year>}

Aggr(

,[Core Source System]

)