Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Honored Contributor III

Re: Filtering rows

Hi,

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

Community Browser