Split listbox values into multiple listboxes based on value type

[psankepalli]

Hello Experts,

Please see the attached document.

I have two list boxes Time Period & Time Values.

When I select the Monthly at Time Period I want to see only Monthly Time Values in Text box.

On MQT Selection at Time Period I want to see only MQT Time Values in Text box. similarly for MAT, YTD and undefined values.

I don't want to use "Hide Excluded" option. I want to show Time Values in 5 different list boxes. based on that Time Period selection that particular Listbox need to visible.

in one line, I want to split Time Values in to 5 different listbox based on the value type.

Please help me

Thanks

Kesav

[sunny_talwar]

Please find attached the qvw and see if this is what you wanted

[psankepalli]

Hi Sunny,

Thank you for your reply.

My Requirement is when I select

Monnthly I want to see only Month values

MQTI want to see only MQTvalues

MATI want to see only MATvalues

YTDI want to see only YTD values

I dont want to see any amy other values in gray color.

Let me know if you need any info from me for more understanding.

Thanks

KR

[sunny_talwar]

May be try it with this expression in list box:

=Aggr(Only({<[Time Value] = p([Time Value])>} [Time Value]), [Time Value])

[psankepalli]

Thats really Awesome. You are my time saver. Thanks A lot 🙂

[psankepalli]

Also, adding question to same requirement..

How to show  "Show Alternative" Values for Time Value. this is not possible at  List box properties because its expression. But I cannot use AGGR function at script level to create new field. Please help me how to achieve this.

Thanks

KR

[sunny_talwar]

Not sure what you are looking for. Can you elaborate?