Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hey guys.
I have created a Pivot Table on Qlikview, which has some calculated fields. I'd like to use the data from these calculated fields they are not available on the database) to create a new Simple Table, something similar to how the GetPivotData function works on Excel.
Is there a similar function on QlikView? If not, how can I get these calculated data from the Pivot to be used on another table?
Thanks!
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		In QlikView you can't get data directly from one object to another. You need to use the same Calculated Fields in another object.
 
					
				
		
 marcus_sommer
		
			marcus_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		It's not a straightforward way but you could export your pivot into a excel- or txt-file and load it again.
- Marcus
