topic Re: how to make filter in table using Qlik Sense in App Development

how to make filter in table using Qlik Sense

rcandeo — Fri, 17 Feb 2017 11:51:46 GMT

I am using Sense and have a table (Option) with only field where the user must select his choice (Direct or Internet)

In this sheet I have a straight (can be Pivot) table that shows Sales data and I have to exclude some lines of this table based on the user choice.

Considering that Sales table has a field called Type_of_Sales with the same options (Direct or Internet). How can I make this filter, considering that I cannot put Type_of_Sales field direct to the user makes the selection?

Re: how to make filter in table using Qlik Sense

ahaahaaha — Fri, 17 Feb 2017 14:53:00 GMT

Hi Robson,

Did you mean it?

You can then choose to either alternate or excluded values.

Regards,

Andrey

Re: how to make filter in table using Qlik Sense

rcandeo — Fri, 17 Feb 2017 17:24:59 GMT

sorry but it is not this my problem. Imagine that you have a straigh table that is not linked to this selection you made, but you need exclude some lines based on a second field that will have the same content that you selected in Dimension1. How would you do that?

Re: how to make filter in table using Qlik Sense

rcandeo — Fri, 17 Feb 2017 17:33:57 GMT

Here is an image of what I need.

In SelectOption you can choose Yes or No

So in below table I must show only the lines where Status content = SelectOption content. How can I do this? I imagine that set analysis can solve but I am not getting the correct syntax

Re: how to make filter in table using Qlik Sense

ahaahaaha — Mon, 20 Feb 2017 12:03:48 GMT

Hi Robson,

Can so, as in the attached file?

Regards,

Andrey

Re: how to make filter in table using Qlik Sense

rcandeo — Mon, 20 Feb 2017 13:40:57 GMT

You made a simple association. What I want is with a secondary table where Status is a different field without any association. See attached please

Re: how to make filter in table using Qlik Sense

ahaahaaha — Tue, 21 Feb 2017 07:54:18 GMT

Hi Robson,

Your question has already been resolved

How can a selection reflects to another using Sense?

Regards,

Andrey

Re: how to make filter in table using Qlik Sense

ahaahaaha — Wed, 22 Feb 2017 02:28:10 GMT

Hi Robson,

Out of curiosity brought his solution to the end (in the attached file). The selection is transmitted to the variable, which is then used in expression Set Analisys.

Thank you for the idea of using "data island" for selections.

Regards,

Andrey