topic Re: Tracking "new" instances using previous command - help !! in QlikView

Tracking "new" instances using previous command - help !!

Fri, 04 Oct 2013 19:04:01 GMT

Hi,

I am trying to identify which concepts have newly appeared at which start_period.

Kindly have a look at the snapshot which covers both the front (table box) and the back end script.

Ex: The "zein" concept though it is OLD it is marked as NEW. Kindly help . and the backend script.

Re: Tracking "new" instances using previous command - help !!

swuehl — Fri, 04 Oct 2013 19:10:02 GMT

I assume your issue is because you create your Start_Period values as text values, then sort ascending in your second load, while you probably assume a chronological sort. Try

Monthname(Start_Period) as Start_Period

for now.

Re: Tracking "new" instances using previous command - help !!

Fri, 04 Oct 2013 19:17:12 GMT

Thanks Swuehl,

That worked like charm.