topic Displaying only last occurance in QlikView

Displaying only last occurance

Mon, 21 Nov 2011 12:58:50 GMT

Hi,

please see example.

could you tell me how to do this?

Displaying only last occurance

Tue, 22 Nov 2011 07:00:06 GMT

No ideas?

Displaying only last occurance

Tue, 22 Nov 2011 14:00:48 GMT

Still nothing. Mayby somebody have idea how to show it in another table? Table should contain only information about PO Number and month, when first transaction occur.

Displaying only last occurance

jagan — Tue, 22 Nov 2011 15:06:22 GMT

Hi Tichan,

I didn't seen any script in the attached file. This can be easily done in script.

In your load script you order the data by PO Number and Month in Desc order, and add an extra column(flag) to mark the row as last occurance row.

The additional column script is

If([PO Number] <> Previous([PO Number]), 1, 0) AS IsLastOccurance

Now, in the table using set analysis {<IsLastOccurance={1}>} you can display only last occurance row.

Regards,

Jagan.