Qlikview Exression

Thu, 19 Nov 2015 16:21:30 GMT

I am designing a bar chart with three expression. Could someone tell me how would i find the difference between two expression

expression1:sum({<
YTD_Flag_Fiscal = {'-1'},
_factTable = {'msData'},
TotalCalcs = {"$(=SubField(Concat(distinct TotalCalcs, '#'), '#', 1))"}
>} value)

expression2:sum({<
LY_YTD_Flag_Fiscal = {'-1'},
_factTable = {'msData'},
TotalCalcs = {"$(=SubField(Concat(distinct TotalCalcs, '#'), '#', 1))"}
>} value)

First expression computes a set of measures like sales, margin etc for 2014 and the second expression computes the same for 2015.

Need to have a third expression showing year on year change = (expression2 - expression1)/ expression 1.

I am unable to find the difference between the two expression using a '-' operator. Is there a diff function similer to a sum function.

topic Qlikview Exression in QlikView

Qlikview Exression