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

Problem of aggregation for "profile" curve

Hi all,

1/ I would like to display the profile of the values which is  the average of all the data by dayname.These profile has to be independant from Date Selection because it has to be deduced from all the existing data.

I tried several expressions without success using something like {1} total <Date>

Is there any solution in the expression ? or script solution is unavoidable ?

Which solution do you think is the best ?

2/

I would like to display in the same chart

- the real values according to the date and

- the profile of the values which is  the average of all the data by dayname.

Is it possible in QV10 ?

I attached an example

Thank you in advanced

Benjamin

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Benjamin,

not sure if I got your request right, but maybe like attached?

Have a nice evening,

Stefan

edit: If you've got only a record per date, I think the expression in the second chart for your profile could be simplified to

=only({1} aggr(nodistinct avg({1}Consumption), DayName))

View solution in original post

2 Replies
swuehl
MVP
MVP

Benjamin,

not sure if I got your request right, but maybe like attached?

Have a nice evening,

Stefan

edit: If you've got only a record per date, I think the expression in the second chart for your profile could be simplified to

=only({1} aggr(nodistinct avg({1}Consumption), DayName))

Not applicable
Author

Thanks.

It answers to my need.