Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor III

multi sourced material expression

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

Expression i tried :

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

All the 100% rows are  single vendor supplied material

so how to not display this 100% rows



1 Reply
Honored Contributor II

Re: multi sourced material expression

not possible in a tablebox,

you may switch to a straight-table and add an expression like

IF(% <> 1, %)

Albeit it might be better to calculate your percentage on the fly, rather than taking it from the script.