topic Re: Grey Out List Box Selection in QlikView

Grey Out List Box Selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a question about list box selection field.

I have a data like this:

SOURCE WEEK

SALES 1

SALES 2

SALES 3

SALES 4

SALES 5

TARGET 1

TARGET 2

TARGET 3

TARGET 4

TARGET 5

TARGET 6

TARGET 7

When I create a list box object it shows week 1 until week 7.

Is it possible for me to grey out target's week, so week 6 and week 7 will be greyed out. so the white one will be only 1 until 5

this is for illustration

The result i expect is week 6 and 7 greyed out (Only week from "SALES" that white)

Is it possible to make it ?

I also attach my sample data and qlikview file.

Thanks in advance

Re: Grey Out List Box Selection

sunny_talwar — Thu, 17 Mar 2016 01:42:41 GMT

What about completely hiding it and not even showing them in the list box?

UPDATE:

Re: Grey Out List Box Selection

Anonymous — Thu, 17 Mar 2016 01:45:34 GMT

Hi Sunny,

Thanks for reply.

That's my second option, but my first option is to show all week and grey out the target's week.

Is it possible ?

really appreciate your help.

Thanks

Re: Grey Out List Box Selection

sunny_talwar — Thu, 17 Mar 2016 01:47:23 GMT

I don't think we can do it in a list box, but we can create a straight table with a look and feel of a list box to do what you are looking for.

Re: Grey Out List Box Selection

tamilarasu — Thu, 17 Mar 2016 01:52:27 GMT

Hi Lejours,

You can place a semi transparent text box over the values. Check the attachment.

Re: Grey Out List Box Selection

jagan — Thu, 17 Mar 2016 02:49:43 GMT

HI,

For this you have to select SALES in the SOURCE field. You can use triggers to make this selection.

Regards,

jagan.

Re: Grey Out List Box Selection

Digvijay_Singh — Thu, 17 Mar 2016 03:59:47 GMT

Check this out, jagan also suggested it

Added trigger on field WEEK, both onselect and onchange.