Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with Expression

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

10 Replies
Anonymous
Not applicable
Author

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