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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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])