topic Re: Re: Two distinct values in set analysis. in QlikView

Two distinct values in set analysis.

anuradhaa — Thu, 27 Mar 2014 10:50:20 GMT

I want to get distinct count of below expression,

=count( {$<UNIT_SINGLE={'UNIT'}>} Distinct(DATE,UNIT_NAME) )

but that doesn't work,

I want to get distinct UNIT_NAME count. but i have to check it with the date.

i mean in the next week i can have same name.

SEE BELOW,

UNIT NAME UNIT_SINGLE DATE

ABC UNIT 2013/02/15

CDE UNIT 2013/02/15

ABC UNIT 2013/02/25

So i want to result for FEB

NUMBER OF DISTINCT SHIPDATE,UNITS

THAT MEANS= 3

PLS HELP

THANK YOU

Re: Two distinct values in set analysis.

alexandros17 — Thu, 27 Mar 2014 10:57:20 GMT

That is not possible, the solution is to concat the fields in order to manage only one field (ex.

ABC_2013/02/15 as new field

Hope it helps

Re: Re: Two distinct values in set analysis.

anuradhaa — Thu, 27 Mar 2014 11:11:18 GMT

Thanks Saccone

SHIPDATE and UNIT_SINGLE is in two tables. So pls help me

Re: Re: Two distinct values in set analysis.

alexandros17 — Thu, 27 Mar 2014 11:18:45 GMT

join the tables (outer join if now are associated) so all fields will be in only one table:

Tab_All:

noconcatenate

select * ... from ... table1

outer join

select * ... from ... table2

MyTable:

noconcatenate

load

field1 & field2 as newfield

resident Tab_All;

drop table Tab_All;

Then use newfield in the count distinct

Re: Two distinct values in set analysis.

CELAMBARASAN — Thu, 27 Mar 2014 11:20:50 GMT

Try with concatenate operator

=count( {$<UNIT_SINGLE={'UNIT'}>} DISTINCT DATE & UNIT_NAME)

Re: Re: Two distinct values in set analysis.

anuradhaa — Thu, 27 Mar 2014 11:25:02 GMT

Thanks All.

Thank you very much.