Qlik Community

Qlik Sense App Development

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

rcandeo
Not applicable

How can a selection reflects to another using Sense?

I am using Sense and I wanna make a selection in one table that reflects no another table.

In example attached I wanna select Yes or No in New_Status (on the right) and wanna this selections repeats automatically in the table on the left for Status field.

I´d use triegger in Qlik View, but as this does not exist in Sense, how can I do this please?

status.jpg

1 Solution

Accepted Solutions
petter
Not applicable

Re: How can a selection reflects to another using Sense?

The Set Expression looks a little bit ugly but it works:

2017-02-21 00_57_37-Qlik Sense Desktop.png

Sum( {<Status={ $(=Chr(39)&Concat(New_Status,Chr(39)&','&Chr(39))&Chr(39)) }>} Amount)

8 Replies
petter
Not applicable

Re: How can a selection reflects to another using Sense?

What do you mean - do you want the selection in New Status to be a filter for the rows in the left-hand table?

vikraant
Not applicable

Re: How can a selection reflects to another using Sense?

Hi Robson ,

I checked out the app, there is no link between Aux Table and Data table. Could you specify what exactly you want to happen when you make selections in the New_Status filter.

Thank You

Vik

rcandeo
Not applicable

Re: How can a selection reflects to another using Sense?

Yes. When my user click on New Status I wanna use this selection (Yes/No) in the table that has Status. So if select Yes, I wanna show only lines that Status = Yes.

The reason for that is that I have a more complex situation where there are tables that cannot be linked.

I think a set analisys could solve this but I am not getting a correct syntax by myself.

rcandeo
Not applicable

Re: How can a selection reflects to another using Sense?

When my user click on New Status I wanna use this selection (Yes/No) in the table that has Status. So if select Yes, I wanna show only lines that Status = Yes.

The reason for that is that I have a more complex situation where there are tables that cannot be linked.

I think a set analisys could solve this but I am not getting a correct syntax by myself.

rcandeo
Not applicable

Re: How can a selection reflects to another using Sense?

anyone please?

petter
Not applicable

Re: How can a selection reflects to another using Sense?

The Set Expression looks a little bit ugly but it works:

2017-02-21 00_57_37-Qlik Sense Desktop.png

Sum( {<Status={ $(=Chr(39)&Concat(New_Status,Chr(39)&','&Chr(39))&Chr(39)) }>} Amount)

rcandeo
Not applicable

Re: How can a selection reflects to another using Sense?

What should I tell? It works, this is the most important.Thank You

vikraant
Not applicable

Re: How can a selection reflects to another using Sense?

I have tried something which is on similar lines as Peter. I defined a variable call vSelection with following expression :

=if(GetSelectedCount(New_Status)<>0, GetFieldSelections(New_Status,',', 10), '*')

Then used the above expression

=Sum({<Status = {'$(vSelection)'}>}Amount)