Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jessreidad
New Contributor

How do you put a filter in a table

I have created a table that I want to pubulish. I only want to display  returnable item.  How do I go about doing it in which I can eliminate the 'Returnable column' from the grid and have the table  just display  values where Returnable = 'Y'.


Is there a way to preset the tables to have it automatically filter a set value such as returnable = 'Y'. ?


Thanks for your help



 

Customer NumberORDERNUMBERDebit Memo NumberReturnableCredit AmountOrder FeeCheck credit Memo  AmountCheck/Credit Memo Number
102102-2016-100EXPNCN041635867N$0.00$0.00$0.00
102102-2016-113EXPAH1216116073Y$7.21$2.10$5.113032411
102102-2016-100EXPAH041638613Y$0.00$0.00$0.00
102102-2016-112EXPAHN1216104320N$0.00$0.00$0.00
102102-2016-100EXPAHN0416035701N$0.00$0.00$0.00
102102-2016-112EXPAHN1216104316N$0.00$0.00$0.00
102102-2016-113EXPAHN1216104316N$0.00$0.00$0.00-
102102-2016-100EXPAHN0416035699N$0.00$0.00$0.00
102102-2016-100EXPAHN0416034443N$0.00$0.00$0.00
102102-2016-113EXPAHN1216100857N$0.00$0.00$0.00
102102-2016-112EXPAH1216108054Y$0.06$0.00$0.063061720
102102-2016-112EXPAHN1216099683N$0.00$0.00$0.00
102102-2016-113EXPAHN1216099683N$0.00$0.00$0.00-
102102-2016-102EXPAH071670286Y$0.00$0.00$0.00
102102-2016-100EXPAH041636827Y$22.18$16.82$5.363028686
102102-2016-112EXPAH1216108472Y$9.02$3.88$5.143032411
Tags (1)
8 Replies

Re: How do you put a filter in a table

Replace the [Credit Amount] field with the expression =Sum({<Returnable={'Y'}>}[Credit Amount])


talk is cheap, supply exceeds demand
hdbucher
New Contributor III

Re: How do you put a filter in a table

Try this....

jessreidad
New Contributor

Re: How do you put a filter in a table

it still shows the returnable

jessreidad
New Contributor

Re: How do you put a filter in a table

I meant to say it still shows the non returnable

vinieme12
Esteemed Contributor II

Re: How do you put a filter in a table

You have to apply the same Set analysis to all the expressions

Re: How do you put a filter in a table

Remove the Returnable field from the table if you didn't already.


talk is cheap, supply exceeds demand
jessreidad
New Contributor

Re: How do you put a filter in a table

I removed the returnable @gysbert wassenaar. I put the filter on the set expression under credit amount. It is still showing the returnable = N... I have one field that I concanated but otherwise it is just a straight table.

Thanks

jessreidad
New Contributor

Re: How do you put a filter in a table

I do not understand what you mean.. Do you mean i need to put this expression on all the measures on that particular table?

Community Browser