Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
its for qlikview.
How to convert columns to rows in the data load editor?
This thread offers some cool information
Hi,
may be it will help you try this
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 |