topic Re: Export to Excel in QlikView

Export to Excel

neha_sri — Thu, 19 Nov 2015 07:09:52 GMT

Hi All,

I have a scenario where I have converted my actual values to absolute value using "round" and "fab" like functions in chart, but I want to export to excel the actual values. Is it possible?

Thanks in advance!

Regards,

Neha

Re: Export to Excel

arulsettu — Thu, 19 Nov 2015 07:12:07 GMT

i think it is not possible. what ever in the chart it will be exported into excel.

Re: Export to Excel

HirisH_V7 — Thu, 19 Nov 2015 07:34:09 GMT

Hi,

Check the attachment .I hope that Helps.

Thanks,

Hirish

Re: Export to Excel

neha_sri — Thu, 19 Nov 2015 08:12:22 GMT

Hi Hirish,

I tried your way, but its not working for me.I already have one chart over other and are trigger based.

Regards,

Neha

Re: Export to Excel

raghvendrasingh — Thu, 19 Nov 2015 08:23:11 GMT

Hi Neha,

Not any direct option for this.but obviously there is workaround:

You need to to create two chart for the same.
In first chart show the caption and use expression with actual values.
In Second chart ,don't show caption and use expression with your functions.
Then paste the second chart on the first chart making layout as top.

Please try this,I hope this will help.

Regards,

Raghvendra

Re: Export to Excel

neha_sri — Fri, 20 Nov 2015 10:55:22 GMT

Hi Raghvendra,

I don't want to export using the option given in caption. In my case user will do right click>Send to excel.

In this case we get the absolute value in excel , not actual value.

Regards,

Neha

Re: Export to Excel

miskinmaz — Fri, 20 Nov 2015 11:16:54 GMT

Hi,

If it is the case where only the user wants to know that this are the negative values and he further don't have to do any calculation, then you can do the following:

1. Remove the round and fab function from your expression

2. Under Number tab, suppose it is a Integer format, then write (#,##0) in format setting. Example: #,##0.00 ; (#,##0.00)

3. Plus you can put text background color, to make to more identifiable.

Regards,

Miskin