Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Table Chart with a custom format

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!!!!

  

     

     

     

     

     

     

     

     

     

     

     

     

7 Replies

Re: Table Chart with a custom format

Could you elaborate/post your data?

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

Not applicable

Re: Table Chart with a custom format

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

Like this?

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

In Fixed to or Integer

#,##0 €

Not applicable

Re: Table Chart with a custom format


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

Attached the same data as on your example.

I do not see Country anywhere.

Attached qvw file not the csv data

Not applicable

Re: Table Chart with a custom format

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

Post your qvw...