topic Re: How to make the report ? in QlikView

How to make the report ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to join the two report ?

The 'Supplementary' needs to be added in the Customer field with log fees -5981844.

Chart 1.

Sample Model attached.

rupamjyotidas — Mon, 26 Jun 2017 19:45:04 GMT

why not concatenate your Fact table and Supplementary table keeping the fields name same for common fiel

like Cust should be Customer in both table and provision should be Logistics_fee

vishsaggi — Tue, 27 Jun 2017 01:44:08 GMT

You have synthetic keys in your model. You have product_key as your key field that joins with other tables.

Can you try like renaming your product code in supplementary table like below and re run your script.

SELECT

[period_key]

,'Supplementary' as Cust

// ,'Supplementary Customer' AS [Customer Code Name]

,[Product Code] AS Suppl_product_code

......

FROM ..... ;

BalaBhaskar_Qlik — Tue, 27 Jun 2017 06:17:12 GMT

Can you try like this:

TableA:

Load Brand,

ProductCode,

Product,

Customer,

LogFees;

Concatenate

TableB:

Load

Cust as Customer,

Provision as LogFees;