Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

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
Partner
Partner

Re: Variance in Pivot Chart

it should be like below 

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

Re: Variance in Pivot Chart

Capture2.JPG

Partner
Partner

Re: Variance in Pivot Chart

sorry this one is correct

Capture2.JPG

ramasaisaksoft
Valued Contributor III

Re: Variance in Pivot Chart

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

Partner
Partner

Re: Variance in Pivot Chart

Hi,

 

below expression is returning 0

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

Partner
Partner

Re: Variance in Pivot Chart

expression is returning value no

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