Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

averaging values using multiple aggregation fields

Hello,

I have a table like this:

ID Date-Time Value

1 12/10/2010 08:00:00 AM 10

1 12/10/2010 08:00:00 PM 20

2 12/10/2010 08:00:00 AM 50

2 12/10/2010 08:00:00 PM 40

1 12/11/2010 08:00:00 AM 20

1 12/11/2010 08:00:00 PM 10

2 12/11/2010 08:00:00 AM 40

2 12/11/2010 08:00:00 PM 60

Now I want to display a straight table that shows avg(value) per id per day

Result:

ID Date Value

1 12/10/2010 15

2 12/10/2010 45

1 12/11/2010 15

2 12/11/2010 50

Does any one know how to do this in qlikview (in the expressions/ in the script...anything is fine)?

Thanks in advance

1 Solution

Accepted Solutions
Not applicable

averaging values using multiple aggregation fields

You can do it completely in the application (no script work). Start with ID as a dimension and then create another dimension: Date([Date-Time]). Then create an expression: Avg(Value).

EDIT: I ended up using Date([Date-Time]) in the load and then using Date#([Date-Time]) as the calculated dimension. Left([Date-Time], 10) may be easiest, since it works in the calculated dimension with no edits in the script.

View solution in original post

2 Replies
Not applicable

averaging values using multiple aggregation fields

You can do it completely in the application (no script work). Start with ID as a dimension and then create another dimension: Date([Date-Time]). Then create an expression: Avg(Value).

EDIT: I ended up using Date([Date-Time]) in the load and then using Date#([Date-Time]) as the calculated dimension. Left([Date-Time], 10) may be easiest, since it works in the calculated dimension with no edits in the script.

View solution in original post

Not applicable

averaging values using multiple aggregation fields

It worked. Thanks so much!