Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

varmekontrol
New Contributor II

Count days if value='string' (Bar Chart)

Hi

I am trying to count the days between today() and another date, but I only want to count if there is some certain information.

I have tried

Count(if(status='In progress', today() - status_date))

1 Solution

Accepted Solutions
MVP
MVP

Re: Count days if value='string' (Bar Chart)

May be this

Count({<status = {'In progress'}>} Today() - status_date)

1 Reply
MVP
MVP

Re: Count days if value='string' (Bar Chart)

May be this

Count({<status = {'In progress'}>} Today() - status_date)