Hidden Excluded option in List box

[psankepalli]

Hello Experts,

Please see the attached document.

I have Two list boxes, one is Time Period and the other one Time Value. Based on the Time Period selection Times values should display in Time value list box.

at STATE A - I am not using any special sorting order.

STATE B- Using Hide Excluded option.

@ STATE A:

My requirement is I want to show Only Months on Monthly Selections, MQT Values for MQT selection. Similarly for MAT and YTD values.

@STATE B: My requirement I can achieve with Hide Excluded option, but the problem is under MONTHLY Group selection I can see around 50 months at Time Value. If I select 10 months out of it, the remaining 40 months are getting Hide because of Hide Excluded option.

I want to show all 50 months with selected 10 months on top. How do I achieve this. Please help me.

If there is a limitation with Qlikview on this feature then suggest me the workaround solution for this.

I appreciate your help.

Thanks

KR

[PrashantSangle]

Hi,

Create list box using expression

try below expression in list box

=if(GetFieldSelections([Time Period])='Monthly',[Time Value],Aggr([Time Value],[Time Value]))

Regards

[psankepalli]

Hi Max Dreamer,

That Doesn't have any impact.  thankyou very much for interest.

Thanks

KR