Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fiorelafantasia
Contributor II
Contributor II

set a kpi to zero

Hi everyone!

I would like to know how to set up a KPI to zero and then change it according to the counts.

Thanks in advance.

Fiorela

Labels (6)
1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi,

For the first one you can create:

Count({$< Category = {"$(=Only(Category)"}>}ID)

For the other one:

Count({$< Category =- {"$(=Only(Category)"}>}ID)

Now you need to select a Category to make it work.

Jordy

Climber

Work smarter, not harder

View solution in original post

4 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

Can you elaborate a bit more what you want? Maybe with an example?

Jordy

Climber

Work smarter, not harder
fiorelafantasia
Contributor II
Contributor II
Author

yes, my idea is set the kpi by default to zero. For example:

Table1

ID

Juan

Maria

Raul

Carlos

Table2

ID,Category

Juan,A

Raul,B

Carlos,A

then, the first KPI could be how many A do I have =  2.

The second KPI could be "how many people do NOT have 'A' " : 2 (raul and maria)

(Count [ID] table1 - count {category=A } [ID]  table 2), so this KPI i would like to set to zero by default, i.e The first display of it should be zero, and then, when I filtering by category  = A, change to 2.

I hope this helps. Thanks in advance.

JordyWegman
Partner - Master
Partner - Master

Hi,

For the first one you can create:

Count({$< Category = {"$(=Only(Category)"}>}ID)

For the other one:

Count({$< Category =- {"$(=Only(Category)"}>}ID)

Now you need to select a Category to make it work.

Jordy

Climber

Work smarter, not harder
fiorelafantasia
Contributor II
Contributor II
Author

thank you a lot !!!! : )