Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Count(if( closed 0 and older then 7 days

Hello,

Probaly it's a small thing what i'm doing wrong, tried many combinations but aint getting te result i want.

if ( IN_closed='0', Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >} IN_number))

Works, but i have to manualy select the IN_closed 0. (by selecting it in list box for example)

count (if(IN_closed='0' , IN_number) )

Works, but it shows all with condition IN_closed 0, i want only results shown wich are 7 days older.

Can someone help me with this?

Thanks in advance!

1 Solution

Accepted Solutions
MVP
MVP

Re: Count(if( closed 0 and older then 7 days

Try

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >}

if ( IN_closed='0', IN_number))

or

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"}, IN_closed = {0} >} IN_number)

2 Replies
MVP
MVP

Re: Count(if( closed 0 and older then 7 days

Try

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >}

if ( IN_closed='0', IN_number))

or

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"}, IN_closed = {0} >} IN_number)

Not applicable

Re: Count(if( closed 0 and older then 7 days

Thank you!

Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >}

if ( IN_closed='0', IN_number))

Works

Community Browser