Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lejours88
Creator
Creator

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

lejours88
Creator
Creator
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

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
Master III
Master III

Check this out, jagan also suggested it

Added trigger on field WEEK, both onselect and onchange.

Capture.JPG