Qliksense: Single client should have single classification value, but when we click on client its displaying mustiple clasification values

[vanir88]

Hi All,

Single client is having multiple client classification values. This is incorrect as there should be 1-1 mapping. A  client will have only a single classification value. how to resolve this in qliksense

thanks in advance

[Or]

Unfortunately, this is not something we can help you with. We have no way of knowing where this classification comes from. I'd suggest you inspect your data source and your code to find out what is causing the issue.

[Vishal_Gupta]

@vanir88 seems like a data mapping/join issue as correctly suggested by @Or . Please provide some more context on your problem.

[vanir88]

we have sales table (we are joining this table with another metadata table with a key SAPContractNbr)

sales table:

SELECT

    DISTINCT opport.Datekey,

    opport.OpportunityId,

    opport.MasterClientClassDesc,

    opport.CountryCd,

    opport.CountryNm,

    opport.MasterCustomerNbr,

    opport.SAPContractNbr,

    opport.IndustryDesc,

    opport.PrimaryWorkLocationDesc,

    opport.ExpectedContractSignDt,

    opport.ActualContractSignDt,

    opport.CompanyCd,

    opport.CurrencyCd

  FROM

    `{project_dataset_raw_saleods}.{project_table_saleods_opportunity_vw_mat}` AS opport

  INNER JOIN (

    SELECT

      OpportunityId,

      MAX(DateKey)AS maxDateKey

    FROM

      `{project_dataset_raw_saleods}.{project_table_saleods_opportunity_vw_mat}`

    GROUP BY

      OpportunityId) AS opport2

  ON

    opport.OpportunityId = opport2.OpportunityId

    AND opport.DateKey = opport2.maxDateKey ) aa

where    aa.SAPContractNbr is not null and aa.SAPContractNbr<>'' ;

metadata table:

operator=bigqueryoperator

task_id=06_dashboard_metadata_acc_vw_full

write_disposition=WRITE_TRUNCATE

destination_dataset_table={project_dataset_alice_in}.dashboard_metadata_acc_vw_full

---sqlscript

sql=select distinct pp.documentcategory,

pp.documenteffectivedate,

pp.contractnumber,

pp.contractname,

case when lower(substr(trim(documentpath),-3))='zip' then doc.real_name else documenttitle end as documenttitle,

pp.engagementenddate,

pp.contractcreateddate,

pp.masterclientnumber,

pp.clientnumber,

case when lower(substr(trim(documentpath),-3))='zip' then concat(documentid, '_' ,suffix) else cast(documentid as string) end as documentid,

pp.documentexpirationdate,

string(date(pp.submissiondate)) as submissiondate,

pp.masterclientname,

pp.clientname,

pp.clientservicegroup,

pp.clientserviceregion,

pp.clientcountry,

pp.contractcountry,

pp.contractregion,

pp.syslastupdated,

''  as contractunit,

deleteflag

from `{project_dataset_alice_in}.es_metadata_ip` pp 

inner join (select documentname as documentname1,regexp_extract(mapping_full_path, r'[^\/]+[^_]+') documentname,

    substr(mapping_full_path,-3) as suffix,real_name

from `{project_dataset_alice_in}.documents_in_hdfs_vw`) doc on pp.documentname = doc.documentname

where date(pp.submissiondate)>='2010-09-01';

we are joining these 2 tables with contractnumber key
in dashboard for example if we select " AB INBEV" from "master client" filter client clasification filter values has to enable only one value instead of 3 values basically it should be 1-1 

[vanir88 · Accepted solution]

Any solutions for this please