# 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?

1 Solution

Accepted Solutions 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

## 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