topic Re: Dimensions under demension in QlikView

Dimensions under demension

anuradhaa — Mon, 16 Nov 2015 13:32:00 GMT

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

Re: Dimensions under demension

sunny_talwar — Mon, 16 Nov 2015 13:32:52 GMT

Pivot table should get this kind of visualization for you

Re: Dimensions under demension

Mon, 16 Nov 2015 13:33:50 GMT

Pivot table is the best choice for your data

Re: Dimensions under demension

Anonymous — Mon, 16 Nov 2015 13:34:36 GMT

Agree with sunny, go for Pivot table..

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

Re: Dimensions under demension

jyothish8807 — Mon, 16 Nov 2015 13:35:07 GMT

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

Re: Dimensions under demension

sunny_talwar — Mon, 16 Nov 2015 13:37:41 GMT

See attached:

Re: Dimensions under demension

jyothish8807 — Mon, 16 Nov 2015 13:40:47 GMT

Hi Anuradha,

PFA a sample.

Regards

Re: Dimensions under demension

anuradhaa — Mon, 16 Nov 2015 13:43:28 GMT

where is that feature

Re: Dimensions under demension

anuradhaa — Mon, 16 Nov 2015 13:47:41 GMT

Sorry, F1 and F2 are two different field.

Thanks

Re: Dimensions under demension

sunny_talwar — Mon, 16 Nov 2015 13:53:06 GMT

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