Discussion Board for collaboration related to QlikView App Development.
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)
Other one is transaction table:
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:
FieldValueCount('Description') as descriptionCheck
(ooxml, embedded labels, table is [Task List]);
Description as Description1,
(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.
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
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
LOAD Task, Description, FieldValueCount('Description') as descriptionCheck
DROP Table Table_A;
//Other one is transaction table:
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