Different format between values display on chart and axis

[vsharma1]

Hi,

I want to display profit values without percentage in below shown combo chart while hovering mouse on profit line however on y axis I want to display profit values in percentage

Attached is the sample data, I am using below formulas 

Revenue= Sum(Revenue)

Profit=Sum(Profit)/Sum(TOTAL Profit)

[vsharma1]

sorry , I could not attach screenshot in my earlier post , above shown is the screenshot of combo chart

I want to display Profit for New York as 0.22 while hovering mouse on profit line

  and I want to display Profit values in percentage  on Y axis on right side  

[Brett_Bleess]

If you can attach a sample app I think it will be easier for someone to help, as they can play with the settings directly etc. versus trying to mimic and do so otherwise, I suspect this may be why you have not received any responses on this one...

Regards,
Brett

[vsharma1]

attached is the sample qvw

[ridone_]

Hi Vsharma,

is this you want to display profit value???  if yes then kindly find the attachment of the qvw

[vsharma1]

sorry, I cannot open qvw due to security reasons. can you please copy paste the solution here or put it in word , image or excel file if content is large    

[Brett_Bleess]

So you cannot open a QVW file but you can open an XLSX?  This does not really make sense, if QVW is a security risk, I would expect the others to be a risk as well, as QVW is no more risky than the others.  If the QVW has macros, you will receive a warning etc. and can choose not to run those etc. to protect from macros running etc.  My other suggestion would be to use a machine not on the network etc. if this is the case, as expecting posters to do the extra steps here is not likely something that is going to happen on a regular basis, so I would say you should find a means to be able to open the files to get what you need from them.

Regards,
Brett

[vsharma1]

Hi,

I do not have licensed version of Qlikview . I am using the licensed version in office where downloading any file is not allowed

I had uploaded Qlikview file in this post from Qlikview installed on my personal laptop which is not a licensed version.

[vsharma1]

Hi,

can you please attach screenshots from qlikview?