topic Re: Different format between values display on chart and axis in QlikView

Different format between values display on chart and axis

vsharma1 — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Different format between values display on chart and axis

vsharma1 — Fri, 05 Jul 2019 03:51:09 GMT

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

Re: Different format between values display on chart and axis

Brett_Bleess — Tue, 30 Jul 2019 20:04:56 GMT

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

Re: Different format between values display on chart and axis

vsharma1 — Wed, 31 Jul 2019 01:40:00 GMT

attached is the sample qvw

Re: Different format between values display on chart and axis

ridone_ — Wed, 31 Jul 2019 09:32:17 GMT

Hi Vsharma,

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

Re: Different format between values display on chart and axis

vsharma1 — Thu, 01 Aug 2019 01:33:07 GMT

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

Re: Different format between values display on chart and axis

Brett_Bleess — Thu, 01 Aug 2019 11:48:42 GMT

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

Re: Different format between values display on chart and axis

vsharma1 — Thu, 01 Aug 2019 23:19:04 GMT

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.

Re: Different format between values display on chart and axis

vsharma1 — Sun, 04 Aug 2019 03:27:08 GMT

Hi,

can you please attach screenshots from qlikview?