Distinct Values

kamalqlik — Sun, 02 Nov 2014 15:04:56 GMT

Hi Guys,

I am having a task list table which is having the list of task,discussion and is coming from excel.

Other is one transaction table which is having this values too with more other filed and date field.

I am giving the small sample of table.

Table are something like this...

Table A:(From Master)

Task	Description
Availability	A
Availability	B
Availability	C
Availability	D
Availability	E

Other one is transaction table:

Table B:

Task	Description	Date
Availability	A	1/1/2014
Availability	B	2/2/2014
Availability	C	3/3/2014
Availability	D	4/4/2014
Availability	E	5/5/2014
Demo	A	6/6/2014
Demo	A	7/7/2014
Demo	A	8/8/2014
Demo	A	9/9/2014

Now I have to join both the table.

I don't want to link the table.

I have the solution by joining the two table.

So something like this:

TaskList:

LOAD Task,

Description,

FieldValueCount('Description') as descriptionCheck

FROM

(ooxml, embedded labels, table is [Task List]);

Left Join

[All Task]:

LOAD Task,

Description as Description1,

Date

FROM

(ooxml, embedded labels, table is [All Task]);

Now what I want is that to get the count of Description field from Task List (which is 5.) to be same after joining the table .

But as we are joining the table the result will be different.

Is there some way is of doing that problem.

Regards,

Kamal

Re: Distinct Values

its_anandrjs — Sun, 02 Nov 2014 15:26:07 GMT

Hi,

You can count this value in the front end after the load of the script like

1. Write the below expression in any text box

Count(DISTINCT Description)

FieldValueCount('Description')

2.If you want to this in the load script then write a load script like

Table_A: //(From Master)

LOAD Task, Description;

LOAD * Inline

[

Task, Description

Availability, A

Availability, B

Availability, C

Availability, D

Availability, E

];

NoConcatenate

NewTableA:

LOAD Task, Description, FieldValueCount('Description') as descriptionCheck

Resident Table_A;

DROP Table Table_A;

Join

//Other one is transaction table:

Table_B:

load Task,Date,Description;

LOAD * Inline

[

Task, Description, Date

Availability, A, 1/1/2014

Availability, B, 2/2/2014

Availability, C, 3/3/2014

Availability, D, 4/4/2014

Availability, E, 5/5/2014

Demo, A, 6/6/2014

Demo, A, 7/7/2014

Demo, A, 8/8/2014

Demo, A, 9/9/2014

];

And following fields you get

Regards

Anand

topic Re: Distinct Values in QlikView

Distinct Values

Re: Distinct Values