Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

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
sunny_talwar

May be this

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

View solution in original post

11 Replies
kunkumnaveen
Specialist
Specialist
Author

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

Capture.PNG

Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kunkumnaveen
Specialist
Specialist
Author

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

Anil_Babu_Samineni

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
shraddha_g
Partner - Master III
Partner - Master III

can you share sample app
?

kunkumnaveen
Specialist
Specialist
Author

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

PFA sample file

kunkumnaveen
Specialist
Specialist
Author

PFA Sample file

kunkumnaveen
Specialist
Specialist
Author

I have shared sample data

Anil_Babu_Samineni

Might stalwar1‌ has some hands on

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)