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: 
vsharma1
Partner - Creator
Partner - Creator

Variance in Pivot Chart

Hi,

I want to calculate variance as shown below in pivot chart

 20182019Variance
Business Segment   
Textile400300-100
Food25030050
Insurance22018040

 

6 Replies
vsharma1
Partner - Creator
Partner - Creator
Author

it should be like below 

  20182019Variance
Business Segment    
TextileSales400300100
NoCustomers2324-1
Budget212112100
FoodSales250300-50
NoCustomers28226
Budget15612432
InsuranceSales22018040
NoCustomers542133
Budget46542243
vsharma1
Partner - Creator
Partner - Creator
Author

Capture2.JPG

vsharma1
Partner - Creator
Partner - Creator
Author

sorry this one is correct

Capture2.JPG

ramasaisaksoft

Hi Sharma,

 

we can create the difference/Variance between expressions in different ways

Way 1: Create a new expression , write 2018 expression- 2019 Expression

Way 2: Create new Expression , write down the title of "2018" expression Name (Which one is -  write down the title of "2019" expression Name

 

1.PNG2.PNG

vsharma1
Partner - Creator
Partner - Creator
Author

Hi,

 

below expression is returning 0

  Count({<[PreviousYTDComp]={'YTD 2018'}>}Claimnumber)

vsharma1
Partner - Creator
Partner - Creator
Author

expression is returning value no

I have implemented difference of two expression based on year but it is giving me only one value