Hidden Excluded option in List box

psankepalli — Fri, 18 Sep 2015 03:52:56 GMT

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

Re: Hidden Excluded option in List box

PrashantSangle — Fri, 18 Sep 2015 04:07:26 GMT

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

Re: Hidden Excluded option in List box

psankepalli — Fri, 18 Sep 2015 14:49:52 GMT

Hi Max Dreamer,

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

Thanks

topic Re: Hidden Excluded option in List box in QlikView

Hidden Excluded option in List box

Re: Hidden Excluded option in List box

Re: Hidden Excluded option in List box