Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Count a number of mins

Hi!

I have a problem with counting number of min values.

So I have a table with orders in one special status. It is sorted by date (orders without date), and in column "Min step number" i have the min step number of order, which has an employee (Name).

How can i count a total amount of mins in this table? It should be grouped by Name, I think.

Thanks in advance!

Screenshot_1.png

5 Replies

Re: Count a number of mins

Is Min Step Number a field or an Measure here? Can you share the expression if it is a measure.

or can you just count distinct name? -> Count(DISTINCT Name)

Not applicable

Re: Count a number of mins

Measure:

Min([ZSLM_E021_MNDT.STEP_NO])

Re: Count a number of mins

I feel Count(DISTINCT Name) should meet the requirement. But you can try this as well:

Count(Aggr(Min([ZSLM_E021_MNDT.STEP_NO]), Name))

Not applicable

Re: Count a number of mins

This "count(aggr(min([ZSLM_E021_MNDT.STEP_NO]), [ID],[Name]))" works!

Thanks!

But there is another problem to put it on the chart. I can't understand how to write it in set analysis.

count({<[Date]={'No date'},[Status]={'В согласовании'} >} [Номер изменения]) - what's ok

but where should i put with part with aggr?

Re: Count a number of mins

May be like this:

Count({<[Date]={'No date'},[Status]={'В согласовании'}>} Aggr(Min({<[Date]={'No date'},[Status]={'В согласовании'}>} [ZSLM_E021_MNDT.STEP_NO]), Name))

Community Browser