Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Average TAT for unique Doc no

Hi

Please assist.

I am looking for an expression that will help me calculate the average TAT for only the unique Doc No.

Please view sample data

Thanks

Tags (1)
6 Replies
balrajahlawat
Esteemed Contributor

Re: Average TAT for unique Doc no

Simply try:

Doc No as a Dim

Expression:  avg(TAT)

balrajahlawat
Esteemed Contributor

Re: Average TAT for unique Doc no

may be this as well?

=aggr(avg(TAT), DocNo)  as Expression

brunobertels
Valued Contributor

Re: Average TAT for unique Doc no

Hi

hope it helps :

Not applicable

Re: Average TAT for unique Doc no

Hi

I need a solution to the below data that will show one Average in a Text box.

It must only do a calculation for the unique Doc No.

Sample data.JPG

reddys310
Honored Contributor II

Re: Average TAT for unique Doc no

HI Charles,

Try this:

Sum(aggr(avg(TaT),Docno))

balrajahlawat
Esteemed Contributor

Re: Average TAT for unique Doc no

Did you try what I suggested you??