Customized List Box

[saumyashah90]

Hi,

I have List of Product and Sub Products.

Product
P1
P2
P3

Sub Product
SP1
SP2
SP3
SP4
SP5
SP6
SP7
SP8

P1 has SP1,SP2,SP3,

P2 has SP4,SP5

P3 has SP6,SP7,SP8

So by default when you click on P1, Sp1,SP2,SP3 will come and other will get grey out.

But i Dont need that.

Now requirement is:

When a Finance Advisor F1 comes, he is tagged to 3 SP's(SP6,SP7,SP8).

So when that F1 is clicked SP6,SP7,SP8 should be seen and others all gets greyed out.

Now for a particular month say October, he has sold only SP6 , I want to see only Sp6 in white and SP7 and SP8 in grey ,I dont want (others to come in the list as it creates confusion for user because other SP's are not tagged to him.)

Please let me know how to do it and also if you dont understand let me know.

[jagan]

Hi,

Select Show Alternatives option in List box properties, this values will be highlighted in Yellow color.  If possible attach a sample file.

Regards,

Jagan.

[saumyashah90]

PFA

Here Select F1,

You will see SP6,SP7,SP8 under him and others are greyed out. Till here its good.

But when you select month Nov, SP6,SP8 are visible and others are greyed out.

But my requirement is only SP7 should be greyed out and others should  not be seen as they are not tagged under him.

Let me know if you need more clarifications

[vikasmahajan]

you can go through this https://community.qlik.com/docs/DOC-4316

Vikas

[vikasmahajan]

also this http://www.qlikfix.com/2014/07/08/building-nicer-dynamic-multibox/

Vikas

[tresesco]

Till some level you want to see greyed out values and then not - would not be possible. May be you can try - 'Hide Excluded' (in General tab).

[saumyashah90]

No not like that,

If its hide Excluded its fine.

But i need to see those Sp's in greyed out for that particular F1

[saumyashah90]

This doesnt helps me..I have attached the sample.Request you to check on the same and let me know if i havent undestood it properly.

[saumyashah90]

Hi Can you help on this?

[saumyashah90]

Can you help on this... Can we do it using Select Possible or something?