Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lionking15
Creator
Creator

Pivot table while using multiple dimension and measure

Hi Guys,

Hope you all are doing well

Facing an issue while creating a pivot table

Output getting

OutPut GettingSum({<A={'a'}>}Amount) Sum({<A={'b'}>}Amount) 
   
A

abab
 
 300050

 

Expected Output

 Sum({<A={'a'}>}Amount)Sum({<A={'b'}>}Amount)
A

ab  
 
 3050  

Above given is a basic scenario i have created.

 

Input table

Load * Inline [
A,B,Amount
a,1,10
a,2,20
b,1,30
b,2,20];

 

Kindly suggest a way to get the expected pivot table. Refer attached file for more clarification

Labels (4)
2 Replies
sunny_talwar

@lionking15 May be use a straight table instead of pivot table?

lionking15
Creator
Creator
Author

Given you the basic scenario,So can't replace the pivot table with straight table