topic Re: function in set analysis is ignoring table dimension in QlikView

function in set analysis is ignoring table dimension

shaybitton — Tue, 21 Aug 2018 12:41:19 GMT

Hi All,

I have a data set with values and descriptions, for example:

value description

1 LOW

2 MEDIUM

3 HIGH

I need to calculate the average and display the description, for example the average is 2 I need to display medium.

I tried to use the function:

Only( {$<[Monitoring Value]={'$(=Floor(AVG({<Source={'Monitoring'}>}[Metric Value for avg])))'}>}[Metric Name])

but it doesn't work for all the values.

I tried with aggr but it doesn't work for all cases as well.

Maybe someone has any idea?

Thanks,

Shay

Re: function in set analysis is ignoring table dimension

sunny_talwar — Tue, 21 Aug 2018 13:13:33 GMT

May be try this:

Pick(Floor(Avg({<Source={'Monitoring'}>} [Metric Value for avg])), 'LOW', 'MEDIUM', 'HIGH')

Re: function in set analysis is ignoring table dimension

shaybitton — Sun, 26 Aug 2018 11:43:24 GMT

Hi Sunny

Thank you for your response,

The problem is, that the value of low, high or medium was only for example, and I have about thousands of metric names, so I can't do It with hard coded.

Any alternative solution?

Thanks,

Shay