how to write expression

[kunkumnaveen]

Hi all,

i need to show only those plant and suppliers whose terms are more then 1

plant      supplier         terms( expression i wrote is  count distinct terms)

xxx          aaa                  4

yyy            bbb                  3

zzz           ccc                     2

kkk           ddd                    1

hhh           eee                    1

but what i need to display is only those terms >1

plant      supplier         terms

xxx          aaa                  4

yyy            bbb                  3

zzz           ccc                     2

how to achieve this plz

thanks

[Peter_Cammaert]

A QlikView table object will show all dimension value sets for which at least one of your expressions results in a non-zero non-null value. If you want to suppress all expression values (whether they are zero or non-zero) based on a single outcome, you can do this by adding the check Tres suggested to ALL your expressions. In this case, add

If(

count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'}>} distinct [Delivery Term])>1,

...

)

to the expression in the Spend column.

Or use the set analysis technique suggested by Anil (which is more efficient)

[passionate]

Hi,

PFA, Solution.

Regards,

Pankaj