How to filter the data table using Filter pane value in Qlik Sense desktop?

[Tamizharasan1]

I have a data table, so I need to filter the data using a 'greater than or equal to' condition based on the values selected by the user from the filter pane.

Tried the above expression
Sum({<[Date_of_Last_Invoice]= {"<=$(=Date(Min([Date_of_Last_Invoice]),'YYYY-MM-DD'))"}>}Invoice)

But shows like Error in expression.

Qlik Sense Desktop   @devarasu07   

[Eva_L]

If you want to combine the two you would only get values for the min Invoice date as one is set to to <= min date and the other to >= min date.

You could still use your master measure if your qlik sense version is high enough

{<[Date_of_Last_Invoice]= {"<=$(=Date(Min([Date_of_Last_Invoice]),'YYYY-MM-DD'))"}>} [Invoice]

where [Invoice] should link to the master measure.

However; you could just use your variable value again from your original formula if you don't want the intersection of the two (aka just the min invoice date)

[Tamizharasan1]

Thanks for your support.

Could you please clarify how to create a measure? I am using a data table with columns containing dimension values from the SELECT query, but I am unsure how to use the measure.

[Ciya]

Which data you want to filter in this table using [Date_of_Last_Invoice] field?

Based on the expression you provided "Invoice" field should filter but this field is not present in your table. To filter the "Invoice" data using the [Date_of_Last_Invoice] field, you either need to have an "Invoice" column in the table or derive it using your business logic.

[Tamizharasan1]

Thanks.

Yes, Invoice does not present in our table using Date_of_Last_Invoice . I need to filter the Date_of_Last_Invoice using a 'greater than or equal to' condition based on the values selected by the user from the filter pane. Also, the filter pane contains Date_of_Last_Invoice values.

Now expression gets resolved but invalid dimension.

This is my query logic

[Tamizharasan1]

Thanks for your support.
Don't have the "Invoice" field but I need to filter the "Date_of_last_Invoice" from the filter pane and filter the  "Date_of_last_invoice" in datatable with condition greater than or equal to.