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

what wrong with my expresssion

Hello,

          i am trying to display Single material supplied by multiple vendor

Dimensions: Material , Vendor Name ,Vendor Code

expressions i tried  are :

1)Spend:

Num(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},Material={"=Count(Distinct [VENDOR CODE])>1"}>}Spend)/100,'#,##0 ')

                                                       or


If(Count(distinct TOTAL <Material> [VENDOR CODE])>1,Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'}>}SPEND))


2)Quantity:


Num(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},Material={"=Count(Distinct [VENDOR CODE])>1"}>}VOLUME)/100,'#,##0 ')


But  the expressions not giving me correct o/p

Capture.PNG

even though the vendor name and vendor code are same but they are two different materials ,they should be considered when i am showing Multi sourced  vendors  because each material as only one supplier..



can any one help in this plz


3 Replies
kunkumnaveen
Specialist
Specialist
Author

even though the vendor name and vendor code are same but they are two different materials ,they should be considered when i am showing Multi sourced  vendors  because each material as only one supplier..

even though the vendor name and vendor code are same but they are two different materials ,they  should not be considered when i am showing Multi sourced  vendors  because each material as only one supplier..

kunkumnaveen
Specialist
Specialist
Author

any suggestions plz

vinieme12
Champion III
Champion III

please post a sample app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.