topic Need to create a new field with values New, Existing in App Development

Need to create a new field with values New, Existing

MS90 — Fri, 15 Nov 2024 20:53:16 GMT

In qliksense I am receiving new record ids every day we get new records, i need to create column showing values 'New','Existing' .

As my data model is complex I can't make change in my existing script and also I can't rely on my date field

In table chart for Record ids column i need to show whether they are New or existing record

The Record ids column after loading data I did some calculation and final Record ids which meets requirment I am showing in Table

Re: Need to create a new field with values New, Existing

marksouzacosta — Tue, 20 Aug 2024 17:55:33 GMT

That sounds like a problem that can be solved with an incremental load process.
Will be very challenging to add this feature you are asking without changing your script. Can you please explain how are you loading the data in your application? Also, is binary load a possible alternative?

Re: Need to create a new field with values New, Existing

MS90 — Wed, 21 Aug 2024 17:01:52 GMT

@marksouzacosta

Maintable:

Load

OrderNo,

Score,

Date,

Otherfields

From lib maintable.qvd(qvd);

DerivedTable:

Load

If (score>60,OrderNo)as OrderNo_Report

Resident Maintable;

RatingTable:

Load

OrderNo,

Rating,

Otherfields

From lib RatingTable.qvd(qvd);

I am daily sendding a report based on OrderNo_Report and Rating>70 ,now I need to add a field in that report showing values 'LatestRecord','Existing'.

I can't reliable on date field because there are more than one date fields and data may updated from any one after daily load.

I need to show records differentiate based on order no only.

I can't use binary load and it is complex data model