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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kfloresc
Contributor II
Contributor II

I need to subtract the value of a column based on the filter date and the last value

I'm new to qlik sense and am having trouble with a simple subtraction with a restricted date filter. Any help would be appreciated 

I am creating a straight table where I need to find the difference between a column's current value based on a selected filter and the value of that column from the last entry.

 

I need to have the filter date within the sheet where users select a date. I have column X (cost), I need to add a column Y (current cost based on selected filter date - the previous value, which is associated with another date)

 

 

Labels (4)
0 Replies