topic Re: Help with Expression in QlikView

Help with Expression

Anonymous — Thu, 24 Mar 2016 21:38:38 GMT

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

Re: Help with Expression

sunny_talwar — Thu, 24 Mar 2016 22:53:36 GMT

May be this

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

Re: Help with Expression

Anonymous — Thu, 24 Mar 2016 23:00:28 GMT

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])

Re: Help with Expression

sunny_talwar — Thu, 24 Mar 2016 23:55:10 GMT

Do you have a sample you can share?

Re: Help with Expression

Peter_Cammaert — Fri, 25 Mar 2016 07:32:50 GMT

"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

Re: Help with Expression

Kushal_Chawda — Fri, 25 Mar 2016 07:39:27 GMT

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

Re: Help with Expression

Anonymous — Fri, 25 Mar 2016 17:15:41 GMT

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

Re: Help with Expression

sunny_talwar — Fri, 25 Mar 2016 17:54:14 GMT

May be this:

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

Re: Help with Expression

Anonymous — Fri, 25 Mar 2016 18:02:15 GMT

yes this worked .. what did * do ?

Re: Help with Expression

sunny_talwar — Fri, 25 Mar 2016 18:06:22 GMT

Union Intersection between your current selection and set analysis

Re: Help with Expression

Anonymous — Fri, 25 Mar 2016 18:10:58 GMT

I am using this expression to show the total no of rows in the caption , but the when I export to excel and I see a different number of records than what is shown with this expression.. can you please see where I am going wrong

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