topic Re: Extra information in chart in QlikView

Extra information in chart

rudywelvaert — Wed, 18 Oct 2017 10:53:18 GMT

Hello,

I'm making a bar chart based on a table that contains following columns: YEAR, CUSTOMER_ID, AMOUNT and REGION

YEAR	CUSTOMER_ID	AMOUNT	REGION
2013	071578	3712,01	Region A
2013	045079	2945,51	Region B
2013	031038	2187,72	Region C
2013	062545	3946,93	Region D
2014	096286	2692,80	Region A
2014	007252	2093,59	Region B
2014	067626	1806,05	Region C
2014	032590	2217,84	Region D
2015	067023	2518,96	Region A
2015	041343	2290,54	Region B
2015	060776	2446,35	Region C
2015	085805	2914,27	Region D
2016	005276	2676,64	Region A
2016	025726	1826,88	Region B
2016	023611	2979,45	Region C
2016	029447	2115,29	Region D
2017	097230	2717,78	Region A
2017	091373	2379,84	Region B
2017	005336	2147,68	Region C
2017	036325	2872,21	Region D

The dimensions of the chart are: YEAR and REGION

The expression of the chart is: AMOUNT

I would like to add the corresponding value of the field CUSTOMER_ID to the tag

so in stead of seeing when over one of the bars

I want to see:

If it is not possible to add CUSTOMER_ID to the tag, an other way to display CUSTOMER_ID in the graph for every bar, is fine too.

I added a qvw as an example.

Thanks

R.W.

Re: Extra information in chart

sunny_talwar — Wed, 18 Oct 2017 11:10:28 GMT

Check attached

Re: Extra information in chart

RonaldDoes — Wed, 18 Oct 2017 11:12:36 GMT

Hi Rudy,

You can add CUSTOMER_ID as an expression.

Please find attached example.

Hope this helps you.

With kind regards,

Ronald

Re: Extra information in chart

kaushiknsolanki — Wed, 18 Oct 2017 11:15:06 GMT

Hi,

Find the attached solution.

Regards,

Kaushik Solanki

Re: Extra information in chart

rudywelvaert — Wed, 18 Oct 2017 11:39:51 GMT

Sunny,

Thanks

Answer is correct but Ronald van der Does' answer is more efficient

R.W.

Re: Extra information in chart

rudywelvaert — Wed, 18 Oct 2017 11:40:32 GMT

Kaushik,

Thanks

Answer is correct but Ronald van der Does' answer is more efficient

R.W.

Re: Extra information in chart

rudywelvaert — Wed, 18 Oct 2017 11:41:09 GMT

Ronald,

Thanks

Very efficient

R.W.

Re: Extra information in chart

sunny_talwar — Wed, 18 Oct 2017 11:42:21 GMT

But it seems that my response is not even helpful ...

Anyways, I am glad you got what you wanted

Re: Extra information in chart

rudywelvaert — Wed, 18 Oct 2017 11:47:49 GMT

sorry I did mark it as helpful

Re: Extra information in chart

sunny_talwar — Wed, 18 Oct 2017 11:51:42 GMT

okay

Re: Extra information in chart

apt091095 — Mon, 15 Jun 2020 19:11:36 GMT

How do I do this on QlikSense?