topic Re: Variance in Pivot Chart in QlikView

Variance in Pivot Chart

vsharma1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to calculate variance as shown below in pivot chart

vsharma1 — Sun, 19 May 2019 22:33:11 GMT

it should be like below

vsharma1 — Sun, 19 May 2019 22:36:48 GMT

vsharma1 — Sun, 19 May 2019 22:45:47 GMT

sorry this one is correct

ramasaisaksoft — Mon, 20 May 2019 07:24:09 GMT

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

vsharma1 — Mon, 20 May 2019 10:05:06 GMT

Hi,

below expression is returning 0

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

vsharma1 — Mon, 20 May 2019 10:29:59 GMT

expression is returning value no

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