topic Re: New Entries in QlikView

New Entries

Mon, 25 Aug 2014 09:43:04 GMT

Hi evrebody , Mensuelly i Load a table i want to show the new entries for example

JULY

ID	FIRST NAME	LAST NAME	DATE OF BIRTH
1	JAMES	MICKAEL	9.06.88
2	SHEPARD	LISA	1.09.93
3	LARGES	STEPHANIE	2.09.92

AUGUST :

FIRST NAME

LAST NAME

DATE OF BIRTH

JAMES

MICKAEL

9.06.88

SHEPARD

LISA

1.09.93

LARGES

STEPHANIE

2.09.92

BEN

INESS

31.07.90

So i want a result like this

NEW ENTRIES :

ID	FIRST NAME	LAST NAME	DATE OF BIRTH

4	BEN	INESS	31.07.90

Thank u for help

Re: New Entries

jagan — Mon, 25 Aug 2014 09:49:57 GMT

Hi,

Data:

LOAD

FROM AugustData;

Concatenate(AugustData)

LOAD

1 AS NewRecordFlag

FROM JulyData

WHERE NotExists(ID);

Now in the front end if you just want to see new records then use NewRecordFlag as filter and Select 1.

Regards,

Jagan.

Re: Re: New Entries

Mon, 25 Aug 2014 10:02:59 GMT

Jagan ,

Its doesnt work ,maybe because i have just one file with data of august and july

can you please see the attachement

Re: Re: Re: New Entries

avinashelite — Mon, 25 Aug 2014 10:19:07 GMT

Hi,

For the above logic to work you should have separate data file like one for today and one of tomorrow . You cannot use it on the same file

Regards,

@vi

Re: New Entries

tresB — Mon, 25 Aug 2014 10:20:14 GMT

There is a space between Not and Exists. So try like: WHERE Not Exists(@1);

Re: Re: Re: New Entries

Mon, 25 Aug 2014 10:24:04 GMT

Hi,

We dont have a other suggestion to resolve my problem

Re: New Entries

tresB — Mon, 25 Aug 2014 10:32:02 GMT

As you are renaming the fields, try like:

WHERE Not Exists(@1, Pivot_NumeroSecuriteSocial )

Re: Re: New Entries

jagan — Mon, 25 Aug 2014 14:24:43 GMT

Hi,

Try like this

Data:

LOAD

FROM TableName

WHERE Month='July';

Concatenate(Data)

LOAD

1 AS NewRecordFlag

FROM TableName

WHERE Month='August';

AND Not Exists(ID);

Now in the front end if you just want to see new records then use NewRecordFlag as filter and Select 1.

Regards,

Jagan.

Re: Re: New Entries

Mon, 25 Aug 2014 15:04:36 GMT

i dont have any element to identify the month