Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

Data minus data(before year)

Hi I need to find the difference of same month different year data.

i.e 2012 Feb value is 2000

     2011 feb value is 1300

Desired value is 700

Is there any ways I can work on this through expression? It will automatically calculate the difference of 3 years data without any user input.

This is my code

(Sum({<
Soldier_Class_Name = {'L'}
,Derived_Status = {'THIP'}
,Unlocode_Port_Of_Sleeping= {EE*'}
>} TEU)

/
Before( Sum({<
Soldier_Class_Name = {'L'}
,Derived_Status = {'THIP'}
,Unlocode_Port_Of_Sleeping= {'EE*'}
>} TEU) , 12)
*100))-100

However, it will display all the values even if it is null value ( i have checked surpress value etc)

untitled.bmp

Therefore my question is, is there any code i can use to substitute the code, before?

Thanks

1 Reply
n1ef5ng1
Creator
Creator
Author

anybody....