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   

[Ruggero_Piccoli]

Hi,

Could you share the error message? 

Qlik Sense stores dates as numeric fields, so check that [Date_of_Last_Invoice] is stored as date field. Be sure that all data types involved in the expression are consistent.

You can use temporary text boxes to verify the results of Min([Date_of_Last_Invoice] and of Date(Min([Date_of_Last_Invoice]),'YYYY-MM-DD').

Best Regards,

Ruggero

[Tamizharasan1]

Hi,

Thanks for your Support.

Verified the results, and it showing as expected, like Date(Min([Date_of_Last_Invoice]),'YYYY-MM-DD').

But when I try to use this line
"Sum({<[Date_of_Last_Invoice]= {"<=$(=Date(Min([Date_of_Last_Invoice]),'YYYY-MM-DD'))"}>}Invoice)"

showing error.

Please find the attachment.

[Ruggero_Piccoli]

Hi,

Try Sum({<[Date_of_Last_Invoice]={">=$(=Min([Date_of_Last_Invoice]))"}>} Invoice). 

This Date(Min([Date_of_Last_Invoice]),'YYYY-MM-DD') is returning a string but the comparsion is with the numeric value [Date_of_Last_Invoice] I suppose.

Best Regards,

Ruggero

[Tamizharasan1]

I tried the Sum({<[Date_of_Last_Invoice]={">=$(=Min([Date_of_Last_Invoice]))"}>} Invoice), but it is still showing an error in expression.

Please find the attachment.

[Ciya]

Hi Tamizh,

Try below expression. use ' instead of ". It's worked for me. 

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

Thanks,

Chaithra

[Tamizharasan1]

Hi Chaithra,

Thanks for your support.

I have tried but it still showing an error in expression and Column invalid dimension. Apart from anything else, I need to modify?

Please find the attachment.

[Eva_L]

In the attached image it looks like it does not know your measure field "Invoice". Is it maybe in lower case or did you rename it?

[Tamizharasan1]

Thanks for your support.

I have tried using different options, as shown in the attachment (Invalid Dimension). Since I am using 'Invoice' as the alias name for the expression, how should I choose the name?

Could you help me on this?

[Ciya]

I have tried below expression in my report, 

Sum({<[Order Date]= {'<=$(=(Min([Order Date])))'}>}COGS)

where,

Measure = COGS

Dimension = [Order Date]

There are fields should highlight in red. I think in your screenshot Invoice is in Black color. Please check once. 

Replace your metrics.