Display in column of straight table value which is dynamically calculated in column expression for specific date
Hello,
I am new to qlikview and need help.
I am in a situation where I would like to populate/display the values for a fixed date in column in straight table. The problem is the values are calculated dynamically.
For example, I have a table (from snapshot taken daily) with DATE_ID in format MM-DD_YYYY and X and Y columns. I have also an input box from which I calculate date dynamically to display. dateToDisplay=(date(today() - '$(vInputBoxVal)', 'MM-DD-YYYY'))
Now I want to create another column, say DiffX_Y in straight table with expression (X - Y), such that if the date is present in the table, it is display the values of (X-Y)for only that specific day.