Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
brom2702
Contributor II
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?

1 Solution

Accepted Solutions
MarcoARaymundo
Creator III
Creator III

11 Replies
Anil_Babu_Samineni

What "Line"

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
brom2702
Contributor II
Contributor II

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

Anil_Babu_Samineni

Do you have Date field?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MarcoARaymundo
Creator III
Creator III

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

please post some sample data and your expected result.

brom2702
Contributor II
Contributor II

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
Contributor II
Contributor II

Thanks, gonna try this one out later today

brom2702
Contributor II
Contributor II

Hi Marco,

Please see attached what I want to achieve.

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

Anil_Babu_Samineni

May be this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)