topic Re: Textbox Result Display in QlikView

Textbox Result Display

Thu, 30 Jun 2016 10:20:01 GMT

Hi Guys,

I have a question on where im having difficulties to get,

I created a textbox based on attached, I need the answer marked in Red to be displayed in Text box instead the one marked in Green is appearing.

Formula:

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

Regards.

Thabiso

Chanty4u — Thu, 30 Jun 2016 11:50:47 GMT

try

=num(count({<Department ={"=Count(score)>=95"}>}Deprtment)/Count(Score)*100 * -1,'#.')

Thu, 30 Jun 2016 12:20:13 GMT

Hi Chanty,

How will i add Department Name Collections?

Regards.

Fri, 01 Jul 2016 09:02:58 GMT

Hi Chanty,

This is not correct please advise how will i add the department name?

Regards,

sunny_talwar — Fri, 01 Jul 2016 15:21:55 GMT

Why do you want to pick 96.90? What is the reason to pick that rather than any other number here? Can you elaborate here?