Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How do i create a count KPI?

Hey guys!
In my table there are two collums ( Journal ID and  Journal ID Line number)
What i want to create is a KPI or something similar, that displays how many Journal IDs there are, that have more than 3 Line Numbers.
Unfortunately the values of the Line Numbers in the dataset are not correct. However, I can use the Count function in the table to show how many Line numbers each Jounal ID has.
Is there any possibility I can 'count the count'  ?

With kind regards,
Lukas

Help.png

1 Solution

Accepted Solutions

Re: How do i create a count KPI?

Try this.

Count({<JournalID = {"=Count([JournalID Line Num])>3"}>}JournalID)

Regards,

Kaushik Solanki

6 Replies
vvira1316
Valued Contributor II

Re: How do i create a count KPI?

Hi,

Will you be able to share your sample data file?

Count(distinct [Journal ID]) should give you count of Different Journal IDs and for

Journal IDs with more than 3 lines will be possible with Set Analysis and variable that will count lines number by Journal ID and using that variable to check it will be >= 3 for Journal IDs of the table

BR

Not applicable

Re: How do i create a count KPI?

Hey, thank you for the fast Reply

The ideo to use set Analysis makes sense to me, however, i am not sure about how to implement it (im quite new to Qlik). Do you have any suggestions?

Here is the data.

sureshqv
Esteemed Contributor III

Re: How do i create a count KPI?

Try this

=count({<[JournalID Line Num]={">3"}>}distinct Journal'ID)

Re: How do i create a count KPI?

Try this.

Count({<JournalID = {"=Count([JournalID Line Num])>3"}>}JournalID)

Regards,

Kaushik Solanki

vvira1316
Valued Contributor II

Re: How do i create a count KPI?

=Count({<[Journal ID]>}[Line Number])

=If(Count({<[Journal ID]>}[Line Number]) >= 3, '3 or More', 'Less than 3')

JRNLLineCount.PNG

vvira1316
Valued Contributor II

Re: How do i create a count KPI?

LOAD

    "Journal ID",

    "Journal ID Line No"

FROM [lib://DataConnect/Test9.xlsx]

(ooxml, embedded labels, table is Tabelle1);