Read user input from filter

[Anonymous]

Hi,

I need to read the user inputs from Filter plane.

How can I implement this in my set expression.?

[charlie_firemind]

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')

or 

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

Thanks

[Vegar]

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?

[Anonymous]

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.?

[Anonymous]

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.?

[Vegar]

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)

[Anonymous]

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.?

[Vegar]

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

count(distinct GuestCode)