topic Re: only last value in QlikView

only last value

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

Hi Folks,

i have one problem,

i use this expression:

M2:

sum(aggr(rangesum(below(total sum({<Month=>}Amount),1,2)),Month)) ,it does work great,

but i want see only last value of selected period, how can i make invisible other value / or to set to Zero.

thanks a lot

beck

Re: only last value

sunny_talwar — Wed, 22 Feb 2017 18:24:21 GMT

May be this:

FirstSortedValue(Aggr(RangeSum(Below(TOTAL Sum({<Month=>}Amount), 1, 2)), Month)), -Month)

Re: only last value

Anonymous — Wed, 22 Feb 2017 18:24:46 GMT

if(rowno(total)=noofrows(total),

sum(aggr(rangesum(below(total sum({<Month=>}Amount),1,2)),Month))

)

Re: only last value

beck_bakytbek — Wed, 22 Feb 2017 18:41:15 GMT

Sunny

Thanks a lot

Re: only last value

beck_bakytbek — Wed, 22 Feb 2017 18:41:46 GMT

Robin

Thanks a lot

Re: only last value

beck_bakytbek — Fri, 24 Feb 2017 13:20:42 GMT

Hi Robin.

i have one question, i have in this case two types of amount, and when i use the set expression, my expression doesnt work

2 types of my amount: UK and USA

i use this expression:

if(rowno(total)=noofrows(total),

sum(aggr(rangesum(below(total sum({<Type = {'UK'},Month=>}Amount),1,2)),Month))

)

do you have any idea?

thanks a lot

beck

Re: only last value

beck_bakytbek — Fri, 24 Feb 2017 13:21:25 GMT

Hi Sunny.

thanks for your feedback, i have in this case two types of amount, and when i use the set expression, my expression doesnt work

2 types of my amount: UK and USA

i use this expression:

if(rowno(total)=noofrows(total),

sum(aggr(rangesum(below(total sum({<Type = {'UK'},Month=>}Amount),1,2)),Month))

)

do you have any idea?

thanks a lot

beck

Re: only last value

sunny_talwar — Fri, 24 Feb 2017 13:30:49 GMT

Not certain, but may be this

If(RowNo(TOTAL) = NoOfRows(TOTAL),

Sum({<Type = {'UK'}>} Aggr(RangeSum(Below(TOTAL Sum({<Type = {'UK'}, Month=>}Amount), 1, 2)), Month)))

Re: only last value

beck_bakytbek — Fri, 24 Feb 2017 13:43:16 GMT

Hi Sunny,

thanks a lot for your help,

but i implemented this code in my expression, and it does not work

beck

Re: only last value

sunny_talwar — Fri, 24 Feb 2017 13:49:30 GMT

When you say it doesn't work, do you mean it gives an error? doesn't show anything? show incorrect result?

Re: only last value

beck_bakytbek — Fri, 24 Feb 2017 13:51:58 GMT

sorry, it doesn't show anything

Re: only last value

sunny_talwar — Fri, 24 Feb 2017 14:02:50 GMT

Would you be able to share a sample app?

Re: only last value

beck_bakytbek — Fri, 24 Feb 2017 14:12:59 GMT

Of course Sunny,

you find my problem under expression: M2 plus test 2

Thanks a lot

Re: only last value

sunny_talwar — Fri, 24 Feb 2017 14:27:04 GMT

May be this:

If(Month = Max({<Type = {'UK'}>} TOTAL Month), Sum(Aggr(RangeSum(Below(Sum({<Month=>}Amount), 1, 2)), Month)))

Re: only last value

beck_bakytbek — Fri, 24 Feb 2017 15:39:10 GMT

Sunny Thanks a lot for your Help and Taking the time to find Solution

Thanks a lot