Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
debabrata_sahoo
Contributor III
Contributor III

How to do column into row in dashboard

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

  My straight table.

DATECODESum of Weight
05-03-2018BR|02154441.7
05-03-2018BR|021610379
05-03-2018BR|022612186
05-03-2018BR|022516012.7
06-03-2018BR|02259450.5
06-03-2018BR|022612458.3
06-03-2018BR|021512552.1
06-03-2018BR|021613424.1
06-03-2018BR|605786185.2
07-03-2018BR|021612156.1
07-03-2018BR|021513467.3
07-03-2018BR|022614249.8
07-03-2018BR|022516239.2
07-03-2018BR|608560265.5
08-03-2018BR|022613822.5
08-03-2018BR|021614569
08-03-2018BR|021516104.9
08-03-2018BR|022521236.1
Total1159901

Requirement Table  

DateBR|0215BR|0216BR|0226BR|0225BR|6057BR|6085TOTAL
05-03-20184441.7103791218616012.743019.4
06-03-201812552.113424.112458.39450.586185.2134070.2
07-03-201813467.312156.114249.816239.260265.2116377.9
08-03-201816104.91456913822.521236.165732.5

Plz help me out.

Thanks,

debabrata

6 Replies
hamza99a
Creator II
Creator II

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
Creator III
Creator III

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
Contributor III
Contributor III
Author

its for qlikview.

hamza99a
Creator II
Creator II

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

This thread offers some cool information

vishweshwarisun
Partner
Partner

Hi,

may be it will help you try this

cap.PNG

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:

DateBR|0215BR|0216BR|0226BR|0225BR|6057BR|6085TOTAL
05-03-20184441.7103791218616012.743019.4
06-03-201812552.113424.112458.39450.586185.2134070.2
07-03-201813467.312156.114249.816239.260265.2116377.9
08-03-201816104.91456913822.521236.15732.5