topic Re: Conditional Values displaying in List Box in QlikView

Conditional Values displaying in List Box

Thu, 08 Aug 2013 18:13:23 GMT

Hi All,

I have two list boxes

Type: Value:

Alpha Ana

Beta Sunny

Mica

West

If I select Type ='Alpha' then Value list box should display Ana and Sunny Only.

If I select Type = 'Beta' Then All Values in 'Value' list bos should be displayed

How to do this?

Re: Conditional Values displaying in List Box

gajapathy74 — Thu, 08 Aug 2013 19:30:56 GMT

Given below is one of the way to filter the Value list box based on Type selection. By join the Type and Value.

Type:

LOAD * INLINE [

Type

Alpha

Beta

];

DataValue:

LOAD * INLINE [

Type, Value

Alpha, Ana

Alpha, Sunny

Beta, Ana

Beta, Sunny

Beta, Mica

Beta, West

];

Re: Conditional Values displaying in List Box

Fri, 09 Aug 2013 19:31:52 GMT

Hi,

Pl find attached document. List box is showing all the associated values.

Instead of this I wanna to limit the values.

Re: Conditional Values displaying in List Box

Oleg_Troyansky — Fri, 09 Aug 2013 23:57:46 GMT

What you want is the feature in the List Box properties, called "Hide Excluded". We typically recommend against it, to show people both associated and not associated values, but in certain cases it's justified to hide the values that are not associated.

Re: Conditional Values displaying in List Box

Sat, 10 Aug 2013 05:29:55 GMT

Hi,

Go to the list box properties->General You can find the option hide excluded so you can hide the excluded values which is not associated with your selection.

Re: Conditional Values displaying in List Box

MayilVahanan — Sat, 10 Aug 2013 05:37:39 GMT

PFA

Hope it helps