topic Re: Using distinct but multiple lines displayed in QlikView

Using distinct but multiple lines displayed

Fri, 18 Sep 2015 20:36:05 GMT

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

Re: Using distinct but multiple lines displayed

evan_kurowski — Sat, 19 Sep 2015 18:02:15 GMT

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

Re: Using distinct but multiple lines displayed

Digvijay_Singh — Sat, 19 Sep 2015 18:07:17 GMT

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

Re: Using distinct but multiple lines displayed

sudeepkm — Sat, 19 Sep 2015 19:00:30 GMT

could you pls upload your qvw file if possible.

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

Re: Using distinct but multiple lines displayed

Digvijay_Singh — Sat, 19 Sep 2015 19:15:54 GMT

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

Re: Using distinct but multiple lines displayed

Mon, 21 Sep 2015 06:13:10 GMT

Hi Can you attach a sample qvw.