How to do calculation in Text Object?

[#1]

Hello everyone,

I am work at a Software Company as a Sales Specialist so I don't have any permission to change anything in the database or add something to the fields so my questions is;

I added a Text Object in my Qlikview 12 and wrote my Sales Target there for the whole year. I also added monthly revenue which can be found below.

= '2016 Sales Target:' & ' ' & '6.860.000 ₺' & '

' & AY & ' ' &  'Status:' & ' ' & money(Sum(SATIRNETTUTARI),'#.##0,00 ₺;-#.##0,00 ₺')

What I want to do is, subtract my whole year Sales Target from the all months to find which percentage that I am at.

To make sense more; We are currently in June, so I select the whole 6 months from my list box to show what my revenue is at the moment which can be found on by Sum(SATIRNETTUTARI). So I want to subtract 6.860.000 from Sum(SATIRNETTUTARI) but I couldn't find how and also add percentage on another line.

I hope I make sense.

Sincerely,

[sunny_talwar]

Really? Can you share a screenshot from Expression Editor

[#3]

yea weird

Even tho it underlines it, the data still works, thats another weird thing

what i meant by data working not the months, that text object still works but i still need to select all the months to show the whole revenue until now.

[sunny_talwar]

I think you need to replace MonthField with a field from your database where you might be making selection in Months. MonthField was just a placeholder

[#5]

hahaha my bad totally forgot about that.

ITS PERFECT You're a life saver. Now, another thing, how can I make the texts bold and underline them?

[sunny_talwar]

Do you want the whole thing to be bold and underlined or part of it? Part of it is not possible using inbuilt QlikView functionalities. You will have to either use multiple text boxes with different formats for each of them or use an extension to do this

[#7]

All right then I will leave the whole thing as it is.

Thank you and appreciate all the help you have given me. oh and also, thank you for ur patience

[sunny_talwar]

No problem at all. I am glad I have been helpful