Discussion Board for collaboration related to QlikView App Development.
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.
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])
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.
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
Hi experts,
Any Inputs?
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])
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
=Sum({<Core_Day=,Core_Month=, Core_Year>}
Aggr(
<AboveExpression>
,[Core Source System]
)
)