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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mrsr2218
Contributor
Contributor

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. 

Any help will be appreciated.

Best Regards,

 

0 Replies