Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shaksmintu
Contributor III
Contributor III

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