Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sum of Distinct Records

Hi

Below is the sample data

  

  

DateMAR         vTAT
2015-04-24150424SCBLAU2SAXXX44958660321:13:41
2015-04-24150424SCBLAU2SBXXX012300400263:41:27
2015-04-24150424SCBLAU2SAXXX449586603365:52:23
2015-04-24150424SCBLAU2SBXXX012300400263:41:27
2015-04-24150424SCBLAU2SBXXX0123004002

63:41:27

Need to find the average of vTAT for DISTINCT MAR using Date as Dimension

Average should be around 43:35:50

It should be displayed as a BAR CHART

Regards

Tags (1)
5 Replies
MVP
MVP

Re: Sum of Distinct Records

May be this:

=Avg(Aggr(Avg(vTAT), MAR))

Highlighted
jebamalai
Valued Contributor

Re: Sum of Distinct Records

Test and confirm

MVP
MVP

Re: Sum of Distinct Records

Please find attached a sample application with the desired output:

Capture.PNG

Capture.PNG

Not applicable

Re: Sum of Distinct Records

Hi

Below is my Requirement

Dimension - > Date

Need to find the average of Time Diff between EndDate and Start Date for Distinct MAR

In the Attached file the average should be 45:35:50

Note: Source file attached as excel in Distinct Sum

Regards,

Senthil

Not applicable

Re: Sum of Distinct Records

Hi

Below is my Requirement

Dimension - > Date

Need to find the average of Time Diff between EndDate and Start Date for Distinct MAR

In the Attached file the average should be 45:35:50

Note: Source file attached as excel in Distinct Sum

Regards,

Senthil

Community Browser