topic Re: flag compare two table in QlikView

flag compare two table

MauriceLudo — Wed, 19 Oct 2016 07:20:23 GMT

Hello,
All codes in Table A are not necessarily present in table B
I would like to add a new type of field flag contennant EMC 'for the codes in both tables and' NO EMC 'for others.
Thank you for your help
cordially
Maurice

Re: flag compare two table

avinashelite — Wed, 19 Oct 2016 07:36:31 GMT

could you please share the sample data for the same??

Re: flag compare two table

MauriceLudo — Wed, 19 Oct 2016 07:47:19 GMT

I can send you in private if you wanted

Re: flag compare two table

avinashelite — Wed, 19 Oct 2016 07:54:38 GMT

I don't need any confidential data

just like this would be enough

Table1:

A,B,C

1,A,aa

2,B,cc

so that we could get an idea how is the data linked and what the comparison we need to do

Re: flag compare two table

MauriceLudo — Wed, 19 Oct 2016 08:05:27 GMT

the two fields to be compared in the table TIERS and CRM_CLIENTS

Re: flag compare two table

vinieme12 — Wed, 19 Oct 2016 08:05:40 GMT

Use ApplyMap to flag available codes in each table

TableA_Codes

MAPPING LOAD

DISTINCT Codes,

'InA' as Flag

FROM TABLEASOURCE;

TableB_Codes

MAPPING LOAD

DISTINCT Codes,

'InB' as Flag

FROM TABLEBSOURCE;

///NOW Add FLAGS TO YOUR Tables

TABLEA:

LOAD *,

Applymap('TableB_Codes',Codes,'NotInB') as CodeFlag

FROM TABLEASOURCE;

TABLEB:

LOAD *,

Applymap('TableA_Codes',Codes,'NotInA') as CodeFlag

FROM TABLEBSOURCE;

Hope it helps !

Re: flag compare two table

vinieme12 — Wed, 19 Oct 2016 08:49:47 GMT

See attached

Re: flag compare two table

MauriceLudo — Wed, 19 Oct 2016 09:21:29 GMT

Nice , thank you very much Vineeth

Re: flag compare two table

MauriceLudo — Thu, 20 Oct 2016 09:29:41 GMT

Hi vinieme12 , please can you help me optimize an application, I made several handling but I have not managed to reduce the response time.

thank you

Re: flag compare two table

vinieme12 — Thu, 20 Oct 2016 10:02:56 GMT

Hi Maurice,

By response time do you mean dashboard performance or data reload time?

This depends on many things, I will need to look into your app and understand your dataset to suggest anything.

How many rows of data you are dealing with?

Is there something in particular that is causing a problem like a pivot/straight table/ chart?

Re: flag compare two table

MauriceLudo — Thu, 20 Oct 2016 10:18:34 GMT

Dashboard performance , yes primarily graphics that poses problem pivot/chart,

how I can send you the application?

Re: flag compare two table

vinieme12 — Thu, 20 Oct 2016 12:17:02 GMT

Create a new thread and post the app/sample app explaining the problem.

There are a lot of great minds here