topic Re: Add counter in QlikView

Add counter

Anonymous — Thu, 19 Oct 2017 12:49:49 GMT

Dear reader,

I want to do the following, when a line (an order for example), appears for the 1st time in the dashboard, I want to give it the mark "New". When it is 1 day later, I want to see it is in 1 day, so give it the mark 1, day after this day becomes 2, and so on.

Any ideas someone?

Re: Add counter

Anil_Babu_Samineni — Thu, 19 Oct 2017 14:47:23 GMT

What "Line"

Re: Add counter

Anonymous — Thu, 19 Oct 2017 14:49:47 GMT

a new line of data/information, were the Order is the unique key

Re: Add counter

Anil_Babu_Samineni — Thu, 19 Oct 2017 15:35:14 GMT

Do you have Date field?

Re: Add counter

MarcoARaymundo — Thu, 19 Oct 2017 18:02:01 GMT

BASE:

LOAD

If(Date(Today(), 'YYYYDDMM') - Date(DATE, 'YYYYMMDD') = 0,

'New',

Date(Today(), 'YYYYDDMM') - Date(DATE, 'YYYYMMDD')

) as Status,

Date(DATE) as DATE,

Upper(DESCRIPTION) as DESCRIPTION,

Num(VALUE) as VALUE;

LOAD * INLINE [

DATE,INVOICE,DESCRIPTION,VALUE

01/10/2017,1,XYZ,100

02/10/2017,2,YZX,50

19/10/2017,10,ZYX,150

];

Re: Add counter

MarcoWedel — Thu, 19 Oct 2017 23:07:52 GMT

please post some sample data and your expected result.

Re: Add counter

Anonymous — Fri, 20 Oct 2017 06:54:10 GMT

Yes, but this is not the correct one, so I need to amend the dashboard and the data a bit, but that is not the problem.

Re: Add counter

Anonymous — Fri, 20 Oct 2017 06:54:48 GMT

Thanks, gonna try this one out later today

Re: Add counter

Anonymous — Fri, 20 Oct 2017 07:15:29 GMT

Hi Marco,

Please see attached what I want to achieve.

Re: Add counter

Anil_Babu_Samineni — Fri, 20 Oct 2017 07:29:21 GMT

May be this?

Date(Today(), 'DD MMM YYYY') - Date([Date insert in list],'DD MMM YYYY')

Re: Add counter

Anonymous — Fri, 20 Oct 2017 07:41:13 GMT

Going to check this, will let you know if it is working. thanks for your time & effort!

Re: Add counter

MarcoARaymundo — Fri, 20 Oct 2017 10:46:45 GMT

Look this