Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
brom2702
New Contributor II

Add counter

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?

Tags (1)
1 Solution

Accepted Solutions
MarcoARaymundo
Contributor III

Re: Add counter

Look this

11 Replies

Re: Add counter

What "Line"

Life is so rich, and we need to respect to the life !!!
brom2702
New Contributor II

Re: Add counter

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

Re: Add counter

Do you have Date field?

Life is so rich, and we need to respect to the life !!!
MarcoARaymundo
Contributor III

Re: Add counter

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

please post some sample data and your expected result.

brom2702
New Contributor II

Re: Add counter

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.

brom2702
New Contributor II

Re: Add counter

Thanks, gonna try this one out later today

brom2702
New Contributor II

Re: Add counter

Hi Marco,

Please see attached what I want to achieve.

20-10-2017 09-14-19.jpg

Re: Add counter

May be this?

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

Life is so rich, and we need to respect to the life !!!
Community Browser