topic Re: Keyword in chart- after export in QlikView

Keyword in chart- after export

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

Hi All,

I need to add a keyword while clicking(send values to Excel). This keyword should be presented for all charts.

For example the below chart exported to excel

Keyword ABC Ltd should appear for all the charts

Thanks in advance

Re: Keyword in chart- after export

stigchel — Mon, 13 Mar 2017 16:07:41 GMT

If 'ABC Ltd' is e.g. a company that is selected and affects the results displayed in the chart, you can add the selection status to exports.

You can add this in the Menu Settings\User Preferences

All selections that affect the result of the chart will be added as text below the results for all charts e.g.

Selection Status:

Company: ABC Ltd

Re: Keyword in chart- after export

Anonymous — Tue, 14 Mar 2017 09:19:08 GMT

Hi Stigchel,

Thanks , really appreciate. Perfect that's what I am searching for .

Please let me know how to remove the label 'Selection Status'. I just need ABC Ltd

Re: Keyword in chart- after export

stigchel — Tue, 14 Mar 2017 09:35:01 GMT

I don't think you can remove 'Selection Status' If you want something custom you can e.g. change the dimension or expression label to what you want, e.g. 'Sales '&Concat(Company,',')