How to do column into row in dashboard

[debabrata_sahoo]

Hi, After getting data from database. How to convert column into row in straight table or pivot table.

  My straight table.

DATE	CODE	Sum of Weight
05-03-2018	BR|0215	4441.7
05-03-2018	BR|0216	10379
05-03-2018	BR|0226	12186
05-03-2018	BR|0225	16012.7
06-03-2018	BR|0225	9450.5
06-03-2018	BR|0226	12458.3
06-03-2018	BR|0215	12552.1
06-03-2018	BR|0216	13424.1
06-03-2018	BR|6057	86185.2
07-03-2018	BR|0216	12156.1
07-03-2018	BR|0215	13467.3
07-03-2018	BR|0226	14249.8
07-03-2018	BR|0225	16239.2
07-03-2018	BR|6085	60265.5
08-03-2018	BR|0226	13822.5
08-03-2018	BR|0216	14569
08-03-2018	BR|0215	16104.9
08-03-2018	BR|0225	21236.1
Total		1159901

Requirement Table  

Date	BR|0215	BR|0216	BR|0226	BR|0225	BR|6057	BR|6085	TOTAL
05-03-2018	4441.7	10379	12186	16012.7			43019.4
06-03-2018	12552.1	13424.1	12458.3	9450.5	86185.2		134070.2
07-03-2018	13467.3	12156.1	14249.8	16239.2		60265.2	116377.9
08-03-2018	16104.9	14569	13822.5	21236.1			65732.5

Plz help me out.

Thanks,

debabrata

[hamza99a]

hello debabrata,

I have used Vizlib extensions. They have powerful straight tables and pivot tables that are much more customizeable than the normal Qlik tables. I definitely would check them out!

Vizlib | Qlik Sense Extension Library

Hope this helps,

Hamza

[jaumecf23]

Hi,

You need to use a pivot table for that. Then drag the CODE dimension of the pivot table to the right over the Expressions.

[debabrata_sahoo]

its for qlikview.

[hamza99a]

How to convert columns to rows in the data load editor?

This thread offers some cool information

[vishweshwarisun]

Hi,

may be it will help you try this

[balabhaskarqlik]

Pivot table:

Dimensions: DATE, CODE

Expression: Sum(Weight) as Sum of Weight.

Drag the Code dimension towards right side and leave.

Now data changes like below:

Date	BR|0215	BR|0216	BR|0226	BR|0225	BR|6057	BR|6085	TOTAL
05-03-2018	4441.7	10379	12186	16012.7			43019.4
06-03-2018	12552.1	13424.1	12458.3	9450.5	86185.2		134070.2
07-03-2018	13467.3	12156.1	14249.8	16239.2		60265.2	116377.9
08-03-2018	16104.9	14569	13822.5	21236.1			5732.5