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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Naruto
Contributor
Contributor

Table with conditional records

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 

Labels (1)
2 Replies
carolgrey98
Contributor
Contributor

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()))})

Naruto
Contributor
Contributor
Author

actually the columns are x and y from which matching values to be not displayed in table