Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Problem of aggregation for "profile" curve

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))

2 Replies
MVP
MVP

Re: Problem of aggregation for "profile" curve

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

Re: Problem of aggregation for "profile" curve

Thanks.

It answers to my need.

Community Browser