topic Re: Read user input from filter in Water Cooler

Read user input from filter

Anonymous — Wed, 14 Nov 2018 11:25:52 GMT

Hi,

I need to read the user inputs from Filter plane.

How can I implement this in my set expression.?

Re: Read user input from filter

charlie_firemind — Wed, 14 Nov 2018 11:50:03 GMT

Hi Kishor,

So depends on how you want to use it inside the expression.

If you made a variable:

SET vKishor = 100;

and then in an expression add

=If(vKishor>50,'yes','no')

=Sum({<FIELD={'$(vKishor)'}>}VALUE)

Thanks

Re: Read user input from filter

Vegar — Wed, 14 Nov 2018 11:53:04 GMT

Could you please explain in a bit more detail?

How does your SET expression look like, in which filter pane is the user making selections?

Re: Read user input from filter

Anonymous — Wed, 14 Nov 2018 12:08:13 GMT

Hi Charlie,

Thanks for the update.

Actually I am looking for,

I have flag filed having 1,2,3,......

If select any of the value in the flag field, that needs to affect my visualization.

How can I read that flag value inside my set expression.?

Re: Read user input from filter

Anonymous — Wed, 14 Nov 2018 12:12:15 GMT

Hi Vegar,

this is set expression :

count({$<Cntflg = {">=5"}>}distinct GuestCode).

I have to put these Cntflg values in a Filter plane and I need to read those values from my set Expression instead of {$<Cntflg = {">=5"}>}.

How can I achieve this.?

Re: Read user input from filter

Vegar — Wed, 14 Nov 2018 12:21:07 GMT

Do you want the set to include both values over 5 and your selected Cntflg or do you want to limit the Cntflg only including the ones you select that are over 5?

Could one of these be your solution?

count({$<Cntflg += {">=5"}>}distinct GuestCode) 
OR
count({$<Cntflg *= {">=5"}>}distinct GuestCode)

Re: Read user input from filter

Anonymous — Wed, 14 Nov 2018 12:27:44 GMT

Hi Vegar,

Actually I am looking for,

I have flag filed i.e., Cntflg having 1,2,3,......

If I select any of the value in the flag field, that needs to affect my visualization.

How can I read that flag value inside my set expression.?

Re: Read user input from filter

Vegar — Wed, 14 Nov 2018 14:10:56 GMT

If your field Cntflg is associated/connected with the remaining datamodel then you don't need to user SET at all.

count(distinct GuestCode)