topic Re: Customized List Box in QlikView

Customized List Box

saumyashah90 — Mon, 30 Nov 2015 05:04:28 GMT

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.

Re: Customized List Box

jagan — Mon, 30 Nov 2015 05:25:54 GMT

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.

Re: Customized List Box

saumyashah90 — Mon, 30 Nov 2015 05:51:38 GMT

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

Re: Customized List Box

vikasmahajan — Mon, 30 Nov 2015 05:57:30 GMT

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

Vikas

Re: Customized List Box

vikasmahajan — Mon, 30 Nov 2015 05:59:22 GMT

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

Vikas

Re: Customized List Box

tresB — Mon, 30 Nov 2015 06:13:36 GMT

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).

Re: Customized List Box

saumyashah90 — Mon, 30 Nov 2015 06:49:05 GMT

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

Re: Customized List Box

saumyashah90 — Mon, 30 Nov 2015 09:05:29 GMT

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.

Re: Customized List Box

saumyashah90 — Mon, 30 Nov 2015 09:06:03 GMT

Hi Can you help on this?

Re: Customized List Box

saumyashah90 — Mon, 30 Nov 2015 09:06:37 GMT

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

Re: Customized List Box

Gysbert_Wassenaar — Mon, 30 Nov 2015 09:34:19 GMT

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.

That's not possible. There is only data for F1 in Nov. So the other SP values are always excluded for Nov.