Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nidsyadav
Partner - Contributor
Partner - Contributor

How to get this format in pivot table in qlik view

    CY21 CY20  
Farmer Total Farmer base 20 lakhs 26 lakhs  
Farmer No of farmers added  8 lakhs 1-1 lakhs  
Farmer No of farmers contacts- 10 lakhs 10.5 lakhs  
Farmer No of unique farmer contacted 9 lakhs -  
Farmer No of farmers contacts 3 lakhs -  
Farmer No of unique farmer contacts - -  
1 Reply
anat
Master
Master

in pivot table take 2  dims and create 2 expressions(1 for CY21 ,2 for CY20)

then use allow pivot option