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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
1 Reply
n1ef5ng1
Creator
Creator
Author

anybody....