User Filter Filtering

karank_*4578
karank_*4578
in Modeling

Hi Guys 

 

I have been trying to solve this issue and having no luck. Reaching out if anyone had a similar issue and was able to solve it with clever tricks 

 

Module 1:- dimensioned by the user ( native user list)

 

karank_0-1613614087395.png

A user enters no of lines as a numeric value 

 

Module 2 :- Dimenshioned by List 1 and List 2. Please note that this is not dimensioned by user list

 

karank_1-1613614167841.png

 

List 2 has items numbers 1 - 15 

 

Question :- I want to filter this module based on the number of line entered by user in module 1 . In my show ( boolean) i have a simple formula . Show is dimensioned by List 2 and users ( native)

if value(name(item)) >= module1.no of lines then true else false

 

Caveats 

 

I cannot dimension module 2 by user 

I would like to avoid FAKE user list 

 

Does anyone has a clever way of acheiving this ?

 

Thanks 

 

Tagged:

Best Answer

  • jasonblinn
    jasonblinn
    Answer ✓

    @karank 

     

    Here is my module 1 per your description. A number of lines can be entered by each user.

    jasonblinn_0-1613623187599.png

     

    In Module 2 I have List 1 as a page selector, and List 2 (which goes from 1-20 in my case).

    I have 2 line items here. 1 is just an arbitrary line item the user can input into, the other is a filter.

    jasonblinn_1-1613623363747.png

     

    in the filter line item, I have it dimensionalized by 1-20 list and users. the filter here is just as you described, saying that it's true if the number is less than or equal to the number input into module 1.

     

    From there, you can apply a filter to your module and select "Users -- Current User--"

    jasonblinn_2-1613623487160.png

     

    I think this achieves your question.

    jasonblinn_3-1613623579548.pngjasonblinn_4-1613623602318.png

     

    Hope this helps!
    Jason

     

     

     

     

Answers

  • JaredDolich
    JaredDolich

    @karank 

    I'm pretty sure you can't accomplish this in a separate module because there's no way to look up the current user. BUT, in the same module that  you collect the line count, you can add the rest of the logic you're looking for. Hopefully this is acceptable since you're going to collect it by user anyway. You'll have to use subsidiary views though.

    Karank003.png

    I select 12, I get 12 lines

    Karank001.png

    I select 10, I get 10 lines.

    Karank002.png

     

  • karank_*4578
    karank_*4578
    Yep this works thanks
  • karank_*4578
    karank_*4578

    Thanks @JaredDolich this works as well

  • JaredDolich
    JaredDolich

    @karank @jasonblinn That was fun. Another!

    I actually like @jasonblinn solution. Cleaner and is closer to what you asked. Didn't think to use the subsidiary view in the second module! Very clever.

Categories