how to write expression

[kunkumnaveen]

Hello All,

                 i am able to achieve my requirement  partially . the thing is i am trying to display only those materials,spend which has supplied by multiple vendors

Expressions i tried :

1)Sum({<SCOPE={'Yes'},Material={"=Count(Distinct [VENDOR CODE)>1"}>}SPEND)

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

but both the expressions are giving me list of  multiple vendors and single vendors materials , as below

All the 100% rows are  single vendor supplied material

so how to not display this 100% rows

Any suggestion plz.....

[tajmohamed30]

my suggestion you can do it in dimension limits show values less than 100% in your chart

[effinty2112]

Hi Naveen,

          Try:

=count(Aggr(if(Count(DISTINCT [VENDOR CODE]) >1,Material), Material))

good luck

Andrew

[kunkumnaveen]

actually i need to implement it in Qlik sense ,i think in qliksense there is no dimension limits option....have u got any alternative way or expression to achieve this requirement ..pz

[kunkumnaveen]

hi,thanks for your reply

Actually i am looking for sum of spend

[kunkumnaveen]

can any suggestion, how to achieve this requirement plz

[kunkumnaveen]

Still look for the suggestions ,in achieving this requirement

[Anonymous]

please post a sample...

[kunkumnaveen]

actually i work in remote server ,so all the app are over there ...can u suggest with any sample expression for this scenario other then i tried plz

[effinty2112]

=count(Aggr(if(Count(DISTINCT [VENDOR CODE]) >1,Spend), Spend))