topic How can a selection reflects to another using Sense? in App Development

How can a selection reflects to another using Sense?

rcandeo — Mon, 20 Feb 2017 17:31:09 GMT

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?

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

petter — Mon, 20 Feb 2017 17:41:28 GMT

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

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

vikraant — Mon, 20 Feb 2017 17:50:33 GMT

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

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

rcandeo — Mon, 20 Feb 2017 19:44:28 GMT

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.

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

rcandeo — Mon, 20 Feb 2017 19:44:58 GMT

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.

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

rcandeo — Mon, 20 Feb 2017 23:11:18 GMT

anyone please?

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

petter — Tue, 21 Feb 2017 00:07:42 GMT

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

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

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

rcandeo — Tue, 21 Feb 2017 00:27:58 GMT

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

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

vikraant — Tue, 21 Feb 2017 05:40:05 GMT

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)