topic Re: Average charts in QlikView

Average charts

eva_maria — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

On my file sample, I need that making a selection in each list box, the chart that depends on that selection show the selected data compared with the average of the rest.

For example, if in the list box Level1 I select 1000, chart show the level 1000 value and in another column, average sales from level 2000 to 5000.

If in the list box Pto I select adj, chart show the adj value and in another column, average sales from the other values.

I appreciate any help.

Regards

Re: Average charts

ogautier62 — Fri, 27 Jul 2018 06:52:10 GMT

Hi,

generally speaking :

to have exclusion of a selection :

avg( {1<amount = E('Pto') >} amount)

E : to exclude value selected in field

1 : to have all values disregard the current selection

regards

Re: Average charts

eva_maria — Fri, 27 Jul 2018 12:30:06 GMT

Thanks Olivier for your reply.

I have used your expresion but i must be doing something wrong because the chart shows "no data to display"

Regards

Re: Average charts

ogautier62 — Fri, 27 Jul 2018 12:59:20 GMT

excuse me,

better I think :

avg( {1<Pto = E(Pto) >} amount) /// without quote in E()

Re: Average charts

eva_maria — Fri, 27 Jul 2018 13:16:46 GMT

Sorry, but show the same result.

Thanks!!