topic Re: Expression partially working in QlikView

Expression partially working

kunkumnaveen — Fri, 24 Nov 2017 08:55:24 GMT

Hello All,

Some thing weird is happening with me, expression is working on one row and not working on another row

I am trying to get minimum NUMBER's Volume ,the expression I wrote is below

Expression:

sum({<SCOPE={'YES'},NUMBER={"$(=Num(min(NUMBER),'000'))"}>}total<[MATERIAL CODE],[VENDOR CODE]>VOLUME)

what I suppose to get is for

0002 and 098C 733114 is min volume(I am getting )

for 40B and 061 473 is min volume (Getting Null)

what am I missing in my expression

Thanks

Re: Expression partially working

kunkumnaveen — Fri, 24 Nov 2017 08:58:10 GMT

when I select only one particular material when it is showing the min volume

Re: Expression partially working

Anil_Babu_Samineni — Fri, 24 Nov 2017 09:00:04 GMT

May be this?

Sum({<SCOPE = {'YES'}, NUNBER = {'$(=Min(NUMBER))'}>} VOLUME)

Re: Expression partially working

kunkumnaveen — Fri, 24 Nov 2017 09:03:39 GMT

HI,i tried your expression ,I am getting both the rows zero, i thinking format for NUMBER has to be there

Re: Expression partially working

Anil_Babu_Samineni — Fri, 24 Nov 2017 09:06:57 GMT

This?

Sum(Aggr(Sum({<SCOPE = {'YES'}, NUMBER = {'$(=Min(NUMBER))'}>} VOLUME), [MATERIAL CODE], [VENDOR CODE]))

Sum({<SCOPE = {'YES'}, NUMBER = {'$(=Min(NUMBER))'}>} TOTAL <[MATERIAL CODE], [VENDOR CODE]> VOLUME)

Re: Expression partially working

shraddha_g — Fri, 24 Nov 2017 09:10:48 GMT

can you share sample app
?

Re: Expression partially working

kunkumnaveen — Fri, 24 Nov 2017 09:21:04 GMT

For some reason both your expression are not working I am sharing those two materials and vendors sample file

PFA sample file

Re: Expression partially working

kunkumnaveen — Fri, 24 Nov 2017 09:27:27 GMT

PFA Sample file

Re: Expression partially working

kunkumnaveen — Fri, 24 Nov 2017 09:37:23 GMT

I have shared sample data

Re: Expression partially working

Anil_Babu_Samineni — Wed, 29 Nov 2017 02:05:26 GMT

Might stalwar1‌ has some hands on

Re: Expression partially working

sunny_talwar — Wed, 29 Nov 2017 03:52:43 GMT

May be this

FirstSortedValue(Aggr(Sum({<SCOPE = {'YES'}>} VOLUME), [MATERIAL CODE], [VENDOR CODE], NUMBER), Aggr(NUMBER, [MATERIAL CODE], [VENDOR CODE], NUMBER))

Re: Expression partially working

shraddha_g — Wed, 29 Nov 2017 14:23:51 GMT

Saviour stalwar1 as always..