topic Re: How calculate in Text Object in QlikView

How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 20:06:33 GMT

Hi guys,

How is possible to simplify the expression in text object:

='Overall NPS= ' &Round (Count({<[Overall experience]={'9-10'}>}[Overall experience])/count(TOTAL [Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience])/

count(TOTAL [Overall experience]),0.001)*100 &' %'

Please see also attached image

Thank you,

Re: How calculate in Text Object

MayilVahanan — Thu, 29 Nov 2012 20:11:38 GMT

May be try like this

='Overall NPS = ' & (Round (Count({<[Overall experience]={'9-10'}>}[Overall experience])/count(TOTAL [Overall experience]),0.001) -

Round(Count({<[Overall experience]={'0-6'}>}[Overall experience])/

count(TOTAL [Overall experience]),0.001))*100

May be it helps

Re: How calculate in Text Object

CELAMBARASAN — Thu, 29 Nov 2012 20:19:20 GMT

Check with this

='Overall NPS= ' &Round ((Count({<[Overall experience]={'9-10'}>}[Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience]))/count(TOTAL [Overall experience]),0.001)*100 &' %'

Edit:

Also add Abs function for the subtraction section.

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 20:32:25 GMT

Hello,

Thanks for replying. What's different in your expression?

regards,

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 20:42:56 GMT

I want to add color condition to this expression.

if the result is less than 0, color red, else blue.

Do you know how to add?

If(...., rgb(red), rgb(blue))

Re: How calculate in Text Object

MayilVahanan — Thu, 29 Nov 2012 20:50:21 GMT

Are you want to add color in chart? or want to display the value in text box? or some other?

Add color in chart:

In expression tab, click '+' sign, add the expression in background color.

if(Count({<[Overall experience]={'9-10'}>}[Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience]))/count(TOTAL [Overall experience]) < 0, red(), blue())

if(your expression < 0, red(), blue())

Hope it helps

Re: How calculate in Text Object

CELAMBARASAN — Thu, 29 Nov 2012 20:54:49 GMT

This is your need?

Please check the attachment..

Sample is for different color appearance in text object

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 21:00:52 GMT

I miss something

='Overall NPS= ' &If((Round (Count({<[Overall experience]={'9-10'}>}[Overall experience])/count(TOTAL [Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience])/

count(TOTAL [Overall experience]),0.001)*100)<0,red(),blue()) &' %'

it looks like

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 21:02:30 GMT

Nice idea. But I need to print it. Sometimes it doesn't match 2 text box in reporter.

Re: How calculate in Text Object

CELAMBARASAN — Thu, 29 Nov 2012 21:04:44 GMT

But there is no other way to highlight only some part in text object in specific color.

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 21:06:07 GMT

Maybe like it

='Overall NPS= ' &If((Round (Count({<[Overall experience]={'9-10'}>}[Overall experience])/count(TOTAL [Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience])/

count(TOTAL [Overall experience]),0.001)*100)<0,red(),blue()) &' %'

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 21:07:09 GMT

I don't know why my image lost

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 21:07:49 GMT

Re: How calculate in Text Object

MayilVahanan — Thu, 29 Nov 2012 21:18:22 GMT

There is no other option to change the color of text box other than font tab in text box. You can increase the size, style, font and color in font tab..

PFA

Edit:

celambarasan already noticed it.. Thanx celambarasan

Re: How calculate in Text Object

CELAMBARASAN — Thu, 29 Nov 2012 21:23:43 GMT

Quick question: Do you need the color for the Whole text or only for the value?

Means Overall NPS = 14% in blue or red or only 14% should be in blue or red?

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 21:24:35 GMT

I don't have name of this variable.

I calculate it in text box. It dependents of these results red or blue color.

I have chart, where I see %. but I don't know how use these % in Text Box

Re: How calculate in Text Object

Anonymous — Thu, 29 Nov 2012 21:25:08 GMT

Only for value

Re: How calculate in Text Object

CELAMBARASAN — Thu, 29 Nov 2012 22:00:09 GMT

Really thats not possible.