Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kamalqlik
Partner
Partner

Distinct Values

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)

TaskDescription
AvailabilityA
AvailabilityB
AvailabilityC
AvailabilityD
AvailabilityE

Other one is transaction table:

Table B:

TaskDescriptionDate
AvailabilityA1/1/2014
AvailabilityB2/2/2014
AvailabilityC3/3/2014
AvailabilityD4/4/2014
AvailabilityE5/5/2014
DemoA6/6/2014
DemoA7/7/2014
DemoA8/8/2014
DemoA9/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

1 Reply
its_anandrjs

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)

Or

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

Op.png

Regards

Anand