Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Displaying only last occurance

Hi,

please see example.

could you tell me how to do this? 

3 Replies
Not applicable

Displaying only last occurance

No ideas?

Not applicable

Displaying only last occurance

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.

MVP
MVP

Displaying only last occurance

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.

Community Browser