Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner
Partner

help with min/max and avg on chart

hi all, i have a chart in the attached qvw which has an expression giving me actuals.

I need to add expressions to show the min/ max and avg but i am not getting much luck in getting it working.

Can anyone help please?

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

=Min(Aggr(COUNT(Type),Hour))

=Max(Aggr(COUNT(Type),Hour))

=Avg(Aggr(COUNT(Type),Hour))

=Min(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

=Max(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

=Avg(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

If you want to show for TOTAL.. use as below

=Min(TOTAL......)

=Max(TOTAL.....)

=Avg(TOTAL......)

View solution in original post

3 Replies
MK_QSL
MVP
MVP

=Min(Aggr(COUNT(Type),Hour))

=Max(Aggr(COUNT(Type),Hour))

=Avg(Aggr(COUNT(Type),Hour))

=Min(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

=Max(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

=Avg(Aggr(Count (Type)/Count(DISTINCT Date),Hour))

If you want to show for TOTAL.. use as below

=Min(TOTAL......)

=Max(TOTAL.....)

=Avg(TOTAL......)

View solution in original post

jyothish8807
Master II
Master II

Hi,

Add these as Expression

=Min(Aggr(COUNT(Type),Hour))

=Max(Aggr(COUNT(Type),Hour))

=Avg(Aggr(COUNT(Type),Hour))

And in dimension put:

User

That will give you 3 lin charts for all users.

Regards

KC

Best Regards,
KC
jyothish8807
Master II
Master II

Sorry, use this:

=Min(Aggr(COUNT(Type),User))

=Max(Aggr(COUNT(Type),User))

=Avg(Aggr(COUNT(Type),User))

And in dimension use:

User

Best Regards,
KC