Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
rcandeo
Contributor III

how to make filter in table using Qlik Sense

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?

Tags (1)
7 Replies
ahaahaaha
Honored Contributor

Re: how to make filter in table using Qlik Sense

Hi Robson,

Did you mean it?

1.

4.jpg

2.

2.jpg

3.

3.jpg

You can then choose to either alternate or excluded values.

Regards,

Andrey

rcandeo
Contributor III

Re: how to make filter in table using Qlik Sense

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?

rcandeo
Contributor III

Re: how to make filter in table using Qlik Sense

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

screen shot.jpg

ahaahaaha
Honored Contributor

Re: how to make filter in table using Qlik Sense

Hi Robson,


Can so, as in the attached file?


Regards,

Andrey

rcandeo
Contributor III

Re: how to make filter in table using Qlik Sense

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

ahaahaaha
Honored Contributor

Re: how to make filter in table using Qlik Sense

Hi Robson,

Your question has already been resolved

How can a selection reflects to another using Sense?

Regards,

Andrey

ahaahaaha
Honored Contributor

Re: how to make filter in table using Qlik Sense

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