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: 
eva_maria
Contributor III
Contributor III

Average charts

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

4 Replies
ogautier62
Specialist II
Specialist II

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

eva_maria
Contributor III
Contributor III
Author

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

ogautier62
Specialist II
Specialist II

excuse me,

better I think :

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

eva_maria
Contributor III
Contributor III
Author

Sorry, but show the same result.

Thanks!!