Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Exression

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.

0 Replies