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: 
Anonymous
Not applicable

Calculate average based upon the Dimensions values.

Hi All,

I have a source dataset like as,

  Source:

CategoryDate

Value_v1

A01/01/2017AM
30518
A01/01/2017PM28484
A01/02/2017AM26806
A01/02/2017PM23227
C01/04/2017AM26083
C01/04/2017PM25642
D01/05/2017AM18996
D01/05/2017PM19939
E01/06/2017AM22555
E01/06/2017PM24746

Output:


    

Category01/01/2017AM11/01/2017PM11/02/2017AM11/22/2017PM
A-7%-6%-13%13%
B-2%-1%4%-3%
C5%-8%1%-11%
D10%5%17%-23%
E-3%0%-2%7%

 

I need to calculate the average % based upon the Date value in the straight tablethe average %That means my calculation will be

Example: Let me consider Category "A" value, for that i need the calculation like


Column1: (01/01/2017AM)


(Value_v1 of 01/01/2017PM) - (Value_v1 of 01/01/2017AM) - / (Value_v1 of 01/01/2017AM)


Column2: (01/01/2017PM)


(Value_v1 of 01/01/2017AM) - (Value_v1 of 01/01/2017PM) - / (Value_v1 of 01/01/2017PM)

Regards,

ShakilaD

0 Replies