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: 
Not applicable

Filtering rows

I want to filter bunch of rows in a straight table based on  'no of offset days'  and show sales amount for that particular date.

So a user can select 10 (or 20 from a drop down) and table should ONLY SHOW RECORDS  where sales_data = sales_date - 10 and sales_amount should show sales for that particular date for that record.

Something like Sum($<sales_date={=$(sales_date)-$(vOffset)}>Sales)

Any help will be appreciated.

Thanks.

1 Reply
sujeetsingh
Master III
Master III

Hi,

You can assign a Variable and then include that variable in your set analysis expression .