topic Re: Table Chart with a custom format in QlikView

Table Chart with a custom format

Wed, 11 Mar 2015 10:27:00 GMT

Hello,

Does anyone know how can I create a table chart with the following format:

Level		Cost	Cost Last Year	Cost YTD	Δ Cost YTD Last year
Store	Virtuals	345 €	42,5%	276 €	46,2%
Group	1	298 €	29,6%	268 €	21,6%
Region	Madrid	120 €	9,0%	114 €	8,9%
Country	Spain	125 €	15,0%	121 €	5,1%

Ive tried to use a pivot table and straigth table but i couldnt do it.

Thanks!!!!

Re: Table Chart with a custom format

robert_mika — Wed, 11 Mar 2015 10:33:11 GMT

Could you elaborate/post your data?

Do you need the money format or green tab???

Re: Table Chart with a custom format

Wed, 11 Mar 2015 11:07:28 GMT

Hi Robert,

Thanks for helping, find attached a small sample of the data source please.

I need the money format.

Thank you.

Re: Table Chart with a custom format

robert_mika — Wed, 11 Mar 2015 11:38:09 GMT

Like this?

I can not reproduce your layout exactly , I can not see any Country column but..

In Fixed to or Integer

#,##0 €

Re: Table Chart with a custom format

Wed, 11 Mar 2015 11:45:38 GMT

Hi Robert,

My biggest problem was not the formatting of the money, reproduce the layout exactly like I inserted in the question is my difficulty.

Re: Table Chart with a custom format

robert_mika — Wed, 11 Mar 2015 11:48:56 GMT

Attached the same data as on your example.

I do not see Country anywhere.

Attached qvw file not the csv data

Re: Table Chart with a custom format

Wed, 11 Mar 2015 11:59:56 GMT

When I posted the the question, I I have changed the field to countries in order to be easy for you to understand, it was just an example, but the aim still the same.

Re: Table Chart with a custom format

robert_mika — Wed, 11 Mar 2015 12:10:12 GMT

Post your qvw...