Commentary

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

So I have two dynamic tables.

They both have a row called Country. Both tables display fine independently.

I want to add the Commentary row to the first table dependant on what Country it is. At the moment, for each Country, ALL the comments appear. I only want the the expression to show each comment for each corresponding country and not show all the comments per country

Table 1

Country	Header 2
UK	XX
IE	XX
ES	XX

Table 2

Country	Commentary
ES	Test
IE	Another test

I can't concatenate as there are 5 expressions using different tables in Table1.

Or can I?

Any help appreciated.

Re: Commentary

kristoferahlin — Thu, 23 Apr 2015 09:49:41 GMT

Hi,

It looks like your 2 Country fields are not linked in the data model. What if you use Country as key field to link the source tables? Or left join the commentary field into the first table.

Are you able to post a sample application?

Cheers,

Kristofer

Re: Commentary

awhitfield — Thu, 23 Apr 2015 09:52:59 GMT

Hi Bobbydave,

how are you adding the comments?

Andy

Re: Commentary

ankitaag — Thu, 23 Apr 2015 10:13:29 GMT

Hey bobby,

Find the attached qvw.

Thanks and Regards,

Ankita

Re: Commentary

jsanchezh — Thu, 23 Apr 2015 10:34:58 GMT

You can join the commentary information to your first table:

left join(table1) Load Country,

Commentary

Resident table2;

Then you will have one table with all the information

Re: Commentary

bobbydave — Thu, 23 Apr 2015 10:43:15 GMT

These are my tables below.

There are some expressions made up using the tables below. The last table is the Commentary table. I just want to take the Comment and match it with the Country of the others. The tables make up one table.

Nulls:
LOAD
Country & '-' & NULLS_Date as %Nulls_Detail,
Country as Nulls.Country,
[Table Name],
[Column Name],
[Count Null],
[Count non-Null],

// if Column Name in Nullls and Column Name in Act_Materialfields_Map match, then

ApplyMap( 'Map_Completeness_Score', [Column Name], 'Error') as Y_Score, //sum([Count non-Null])) as tests,

NULLS_Date,
NULLS_Country_Code
FROM

(qvd);

Logs:
LOAD
COUNTRY_CD & '-' & Logs_Date as %Logs_Detail,
COUNTRY_CD as Logs.Country,
ACC_PERIOD,
HEAD_ROWCOUNT,
DETAIL_ROWCOUNT,
TIA_CLAIMS,
Logs_Date,
Logs_Country_Code
FROM

(qvd);

GL_AUDIT:
LOAD
Country & '-' & GLA_Date as %GL_Detail,
Country as GLA.Country,
Period,
[GL Rep46Proc],
[Claims Ext],
Difference,
[% Difference],
Outcome,
GLA_Date,
GLA_Country_Code
FROM

(qvd);

ERRS:
LOAD
ERRS_Country_Code & '-' & ERRS_Date as %ERRS_Detail,
CLA_CASE#,
ERRS_Date,
ERRS_Country_Code as ERRS.Country
FROM

(qvd);

Count_Value:
LOAD
Country & '-' & CV_Date as %CV_Detail,
Country as Count.Country,
Source,
Status,
[Claim Count],
[Total Claims Benefit],
CV_Date,
CV_Country_Code
FROM

(qvd);

[IT Commentary]:
LOAD Country & '-' & Commentary_Date as %IT_Commentary_Detail,
Country as ITComm.Country,
[IT Period] as ITCommPeriod,
Measure,
Comment,
[Mgt Action],
Commentary_Date,
Commentary_Code
FROM

(qvd);

KEY TABLE BELOW

KeyTable:
Load
%GL_Detail,
ApplyMap('Countries_MAP', GLA_Country_Code, 'MISSING') as [Country],
GLA.Country as [Country Code],
date(date#(GLA_Date, 'YYYY-MM')) as %KEY_Calendar

Resident GL_AUDIT;

Concatenate (KeyTable)
Load
%Logs_Detail,
ApplyMap('Countries_MAP', Logs.Country, 'MISSING') as [Country],
Logs.Country as [Country Code],
date(date#(Logs_Date, 'YYYY-MM')) as %KEY_Calendar

Resident Logs;

Concatenate (KeyTable)
Load
%ERRS_Detail,
ApplyMap('Countries_MAP', ERRS.Country, 'MISSING') as [Country],
ERRS.Country as [Country Code],
date(date#(ERRS_Date, 'YYYY-MM')) as %KEY_Calendar

Resident ERRS;

Concatenate (KeyTable)
Load
%Nulls_Detail,
ApplyMap('Countries_MAP', Nulls.Country, 'MISSING') as [Country],
Nulls.Country as [Country Code],
date(date#(NULLS_Date, 'YYYY-MM')) as %KEY_Calendar

Resident Nulls;

Concatenate (KeyTable)
Load
%CV_Detail,
ApplyMap('Countries_MAP', Count.Country, 'MISSING') as [Country],
Count.Country as [Country Code],
date(date#(CV_Date, 'YYYY-MM')) as %KEY_Calendar

Resident Count_Value;

Concatenate (KeyTable)
Load
%IT_Commentary_Detail,
ApplyMap('Countries_MAP', ITComm.Country, 'MISSING') as [Country],
ITComm.Country as [Country Code],
date(date#(Commentary_Date, 'YYYY-MM')) as %KEY_Calendar

Resident [IT Commentary];

topic Re: Commentary in QlikView

Commentary

Re: Commentary

Re: Commentary

Re: Commentary

Re: Commentary

Re: Commentary