Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Grey Out List Box Selection

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

week1.png

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

week2.png

Is it possible to make it ?

I also attach my sample data and qlikview file.

Thanks in advance

6 Replies
sunny_talwar

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

UPDATE:

Capture.PNG

Anonymous
Not applicable
Author

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

sunny_talwar

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.

tamilarasu
Champion
Champion

Hi Lejours,

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

jagan
Luminary Alumni
Luminary Alumni

HI,

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

Regards,

jagan.

Digvijay_Singh

Check this out, jagan also suggested it

Added trigger on field WEEK, both onselect and onchange.

Capture.JPG