Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

Expression partially working

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)

Capture.PNG


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









1 Solution

Accepted Solutions

Re: Expression partially working

May be this

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

11 Replies
kunkumnaveen
Contributor III

Re: Expression partially working

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

Capture.PNG

Re: Expression partially working

May be this?

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

kunkumnaveen
Contributor III

Re: Expression partially working

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

This?

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

OR

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

shraddha_g
Honored Contributor III

Re: Expression partially working

can you share sample app
?

kunkumnaveen
Contributor III

Re: Expression partially working

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

PFA sample file

kunkumnaveen
Contributor III

Re: Expression partially working

PFA Sample file

kunkumnaveen
Contributor III

Re: Expression partially working

I have shared sample data

Re: Expression partially working

Might stalwar1‌ has some hands on

Community Browser