Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

FX help for KPI

Hi,

Please could i ask for your help with this FX

I am trying to create a KPI that counts the Discover only over the last seven days ignoring blank fields

I would like one for seven days, twenty-eight days and ninety days

The FX created doesn't return the correct count???

Count({$<[Discovery Assignee]={"Gordon"},[Discovery Sign Off Date]={*}>*(<DaysAgoImport={0,1,2,3,4,5,6}>)}[Discovery Sign Off Date])

it seems to be only counting the the "Discovery Assignee" field?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: FX help for KPI

Is the last 7 day number of Gordon  = 6? May be try this:

Count({$<[Discovery Assignee]={"Gordon"},[Discovery Sign Off Date]={"$(='>=' & Date(Max([Discovery Sign Off Date])-7) & '<=' & Date(Max([Discovery Sign Off Date])))"}>}[Discovery Sign Off Date])

7 Replies
Highlighted
MVP
MVP

Re: FX help for KPI

What is the expected output here?

MVP
MVP

Re: FX help for KPI

Is the last 7 day number of Gordon  = 6? May be try this:

Count({$<[Discovery Assignee]={"Gordon"},[Discovery Sign Off Date]={"$(='>=' & Date(Max([Discovery Sign Off Date])-7) & '<=' & Date(Max([Discovery Sign Off Date])))"}>}[Discovery Sign Off Date])

Not applicable

Re: FX help for KPI

Hi,

I would like to count how many Discoveries were completed (Discovery sign off date) by Gordon / Victor / Bryan over the last 7 days or 28 or 90 days

but ignoring the blank cells

MVP
MVP

Re: FX help for KPI

Have you checked the attached qvf above?

Not applicable

Re: FX help for KPI

Hi Sunny,

sorry I've been off line, their is no qvf attached?

i will try the FX now

MVP
MVP

Re: FX help for KPI

Open this link to check the qvf

Re: FX help for KPI

Not applicable

Re: FX help for KPI

Thank you So much