topic Re: Table with conditional records in Management & Governance

Table with conditional records

Naruto — Wed, 27 Nov 2024 08:22:41 GMT

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

Re: Table with conditional records

carolgrey98 — Wed, 27 Nov 2024 08:26:11 GMT

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

Re: Table with conditional records

Naruto — Wed, 27 Nov 2024 11:48:35 GMT

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