Help with Expression

[Anonymous]

Hi

Here is my expression, I have a straight table with plenty of dimensions and the below is the only expression , I want the data to be shown only for past 24 weeks , when I click on any dimension from the table it filters down to the selected value , but when I click on Created column the data does not filter , what change I have to make in order to make the Created date selections to work from the straight table

Only({<Created={">=$(=Date(Today()-168))"}>}[Jira Key]&'<URL>'&'https://jira.xyz.com/browse/'&[Jira Key])

Thanks

[sunny_talwar]

May be this 

{<Created={">=$(=Date(Max(Created) - 168))<=$(=Date(Max(Created)))"}>}

[Anonymous]

so I used this as my expression, but it did not work ..

Only({<Created={">=$(=Date(Max(Created) - 168))<=$(=Date(Max(Created)))"}>}[Jira Key]&'<URL>'&'https://jira.xyz.com/browse/'&[Jira Key])

[sunny_talwar]

Do you have a sample you can share?

[Peter_Cammaert]

"It doesn't work" is not the most useful feedback you can give.

What does this expression return? Does it return a NULL value? Multiple values? The wrong value?

Do you get syntax errors in the expression editor (marked by red wiggly lines)?

The most probable cause of problems is that your expression will return multiple results for the set of dimension values. In that case, Only() will return a NULL value. So, if you replace Only with Concat, do you get output? Is the correct output amongst the results of the expression?

Peter

[Kushal_Chawda]

Can you please elaborate? What you are trying to achieve is not clear

[Anonymous]

Attached is my application , the problem is I am unable to select a date from the chart , when I click on a date it does not filter down to select date. where as other columns will filter as per the selected values

[sunny_talwar · Accepted solution]

May be this:

Only({<Created*={">=$(=Date(Today()-168))"}>}[Jira Key]&'<URL>'&'https://jira.intuit.com/browse/'&[Jira Key])

[Anonymous]

yes this worked .. what did * do ?

[sunny_talwar]

Union Intersection between your current selection and set analysis