Using distinct but multiple lines displayed

[#1]

Hello -

I'm trying to create a straight table which displays distinct 'Batch.BatchID' when the 'LIID' is not 10000, but I'm still getting multiple lines for each BatchID when using the following expression:

count(distinct if(LIID<> '10000', Batch.BatchNbr)) 

Any ideas?

Thanks,

Lindsay

[evan_kurowski]

You may have undisplayed fractions on some of those values.  Does LIID have any data below the decimal point?

[Digvijay_Singh]

Any reason you are using single quote around 10000? If its a number you can directly compare without embedding it with quote.

[sudeepkm]

could you pls upload your qvw file if possible.

I'm not clear what are your dimensions and expression.

[Digvijay_Singh]

Your expression as Batch.BatchNbr but in details you have used Batch.BatchID. Hope it is just a typo

[#6]

Hi Can you attach a sample qvw.