Skip to main content
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