Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have loaded 2 columns today and yesterday with values where in i need to display the records in table only when they are not equal with few other columns in the table Data.
How to achieve this via expression of Qlikview Desktop?
Thank You
To display records in a table in QlikView Desktop only when certain conditions are met, you can use conditional expressions. Here's a basic example of how you can achieve this:
1. Load your data: Load the two columns with values for today and yesterday Adult Proxy Form
2. Create a condition: Use the if function to check if the values in the two columns are not equal.
3. Apply the condition: Use this condition in your table's expression to filter the records.
Here's a sample expression:
=if(Not({$(=Date(Today()) - Date(Yesterday()))} = {$(=Date(Today()) - Date(Yesterday()))}), {$(=Date(Today()) - Date(Yesterday()))})
actually the columns are x and y from which matching values to be not displayed in table