SET ANALYSIS Filter selection not working on the table drop down search

[itsme123]

Hi All

Please advise , I have to design a report by defaulting the table to show only last 30days of data from today

I have a table  invoiceid,amountdue,invoicedt,org . I have created variable vlast30days==date((today()-30),'MM/DD/YYYY')

I have applied set analysis on the column amount due

=sum({$<org={'x'},[invoicedt]={">=$(vlast30days)"}>}[amountdue])

the table works fine by filtering data to show only last 30days.

However when i click on the invoicedt column it shows all the records from the data set irrespective of last 30days how do i limit this invoice dt to column to show last 30days. it seems all other columns are also showing in the same way when i click on search (magnifier) icon

[anushree1]

please try:

=sum({$<org={'x'},[invoicedt]={">=$(vlast30days)"},[invoicedt]>}[amountdue])

[Vegar]

You are correct in your observation, you have only limited your your expression calculation not the available fieldvalues. To achieve what you want you will need to create a calculated dimension that only includes the last 30 days.

Try something like this in you dimension column
= if(YourDateField >= $(vlast30days), YourDateField, Null() )

[itsme123]

thank you for your response
this did not work ,infact the results came out without satisfying last30days condition

[Vegar · Accepted solution]

I created some mockup data and tried to reproduce your issue. See screnshot and attached qvf.

For the dimension I used the following expression:

=if(invoicedt>='$(=vlast30days)',invoicedt)

[itsme123]

Vegar Thank You So much it worked.
My earlier response was for Anushree1. However your screenshot and attached file made it more simpler for me 🙂