topic Re: Bar chart: expression based on two Average-functions in QlikView

Bar chart: expression based on two Average-functions

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

Hi all,

The following expression works fine in a table

= (Avg({<Gennemført={'Y'} , [uniTEST]={'1'}, [UDD_KODE]={'17015'}>} SCORE)) - (avg({1< uniTEST ={'1'}, Gennemført = {'Y'}>} SCORE))

however, I'm getting a " no data to display" in a bar Chart.

Can anyone help?

thanks

best agner

sunny_talwar — Fri, 04 Aug 2017 15:04:22 GMT

Do you have the exact same dimensions in your table and bar chart?

schibler — Mon, 07 Aug 2017 05:15:07 GMT

Hi Sunny,

ohhh g... That's embarrassing. But you're right, I've forgotten dimensions, thanks for the help.

best Agner