User Filter Filtering

karank
Regular Contributor

User Filter Filtering

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 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jasonblinn
Master Anaplanner/Community Boss

Re: User Filter Filtering

@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

 

 

 

 

View solution in original post

5 REPLIES 5
JaredDolich
Moderator

Re: User Filter Filtering

@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

 


Jared Dolich
karank
Regular Contributor

Re: User Filter Filtering

Thanks @JaredDolich this works as well

JaredDolich
Moderator

Re: User Filter Filtering

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


Jared Dolich
jasonblinn
Master Anaplanner/Community Boss

Re: User Filter Filtering

@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

 

 

 

 

View solution in original post

karank
Regular Contributor

Re: User Filter Filtering

Yep this works thanks