topic Re: Text object result in QlikView

Text object result

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

I have an issue where the results in my text box object is different comparing it to my table chart, please see attached image for more clarity(Formula below).

I am trying to display the score by department and i need the score in RED to appear in my text object, but instead the score in GREEN is appearing, is there something I'm missing??(Please have a look at the attached to see what I mean)

=Num(sum({< Department = {'Contracts', 'Spending','Agri'} >}Score >=95) / Count(Score)*100 * -1,'#.')

Kind regards,

Justin

Re: Text object result

deepakqlikview_123 — Mon, 04 Jul 2016 06:35:50 GMT

can u plz share sample data

Re: Text object result

arasantorule — Mon, 04 Jul 2016 06:39:55 GMT

Hi,

I believe the attached image is a table chart.

However you are expecting the highlighted result in the text box (Single Value).

Please can you verify if you are missing any more condition in set analysis.

Thanks.

Re: Text object result

Mon, 04 Jul 2016 06:43:08 GMT

Yes that's correct .

I am not missing any conditions here.

Thanks

Re: Text object result

Mon, 04 Jul 2016 06:49:11 GMT

Sample data attached, thanks.

Re: Text object result

MindaugasBacius — Mon, 04 Jul 2016 06:56:00 GMT

Try changing this:

Re: Text object result

Mon, 04 Jul 2016 06:58:22 GMT

Hi Mindaugas Bacius

I need this results in a text box not a table chart

thanks

Re: Text object result

Mon, 04 Jul 2016 06:58:41 GMT

Yes that's correct .

I am not missing any conditions here.

Thanks

Re: Text object result

arasantorule — Mon, 04 Jul 2016 07:31:35 GMT

Can you share the qvw if possible?

Are you calculating the value only when Score >=95.

Are you expecting the result in text-box for Department = {'Contracts', 'Spending','Agri'} and where Score >=95.

Thanks.

Re: Text object result

Mon, 04 Jul 2016 07:35:14 GMT

That's correct

Re: Text object result

arasantorule — Mon, 04 Jul 2016 07:36:19 GMT

I think the sample data provided is not in full.

Thanks.

Re: Text object result

arasantorule — Mon, 04 Jul 2016 07:55:48 GMT

Can you share the sample data with all fields used in the expression

Thanks.

Re: Text object result

qliksus — Mon, 04 Jul 2016 08:17:30 GMT

Looks like you are trying to create Average but as per the data and the calculation you posted

The value of sum({< Department = {'Contracts', 'Spending','Agri'} >}Score >=95) = 196

The value of Count(Score) = 17

The result is thus = 11 but ur chart is showing 0.85

Can you post a sample file to understand this better ?