Dimensions under demension

[anuradhaa]

Hi,

is it possible to display this type of chart in qlikview

	Country
	USA		UK		Farnce
	F1	F2	F1	F2	F1	F2
Name 1	100	46	454	54	44	44
Name 2	1514	444	545	445	5454	454
Name 3	16416	54	45	454	54	545

Thanks

[sunny_talwar]

Pivot table should get this kind of visualization for you

[#3]

Pivot table is the best choice for your data

[Anonymous]

Agree with sunny, go for Pivot table..

Use slicing/dicing feature for Country,F.. Dimension

[jyothish8807]

Hi Anuradha,

This can be achieved by using pivot chart. Can you please share your raw file to see the format in which you are receiving data ?

Regards

KC

[sunny_talwar]

See attached:

[jyothish8807]

Hi Anuradha,

PFA a sample.

Regards

KC

[anuradhaa]

where is that feature

[anuradhaa]

Sorry,  F1 and F2 are two different field.

Thanks

[sunny_talwar · Accepted solution]

Should be the same still:

New Script:

Table:

LOAD * Inline [

NAME, COUNTRY, F1, F2

Name 1, USA, 100, 46

Name 1, UK, 454, 54

Name 1, FRANCE, 44, 44

Name 2, USA, 1514, 444

Name 2, UK, 545, 445

Name 2, FRANCE, 5454, 545

Name 3, USA, 16416, 54

Name 3, UK, 45, 454

Name 3, FRANCE, 54, 545

];

Dimension: NAME, COUNTRY

Expression: F1, F2