Re: Add counter

Anonymous · ‎2017-10-19

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?

Anil_Babu_Samineni · ‎2017-10-19

What "Line"

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-10-19

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

Anil_Babu_Samineni · ‎2017-10-19

Do you have Date field?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

MarcoARaymundo · ‎2017-10-19

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

];

MarcoWedel · ‎2017-10-19

please post some sample data and your expected result.

Anonymous · ‎2017-10-20

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.

Anonymous · ‎2017-10-20

Thanks, gonna try this one out later today

Anonymous · ‎2017-10-20

Hi Marco,

Please see attached what I want to achieve.

Anil_Babu_Samineni · ‎2017-10-20

May be this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Add counter

QlikView App Dev