Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Brownie
Contributor III
Contributor III
‎2023-04-10 03:28 AM

Convert Row fields in one field

The data is like this.

Brownie_0-1681111551971.png

i need all the column fields in one row and the data infront of it. 

NSV is net sales.

volume is quantity

Brownie_1-1681111574986.png

 

 

Labels (4)
Labels
339 Views
0 Likes
1 Reply
vinieme12
Champion III
Champion III
‎2023-04-11 02:28 AM

refer CrossTable Load

 

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

 

You can transpose the data on the Material and Date field

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
277 Views
0 Likes