Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What about completely hiding it and not even showing them in the list box?
UPDATE:
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
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.
Hi Lejours,
You can place a semi transparent text box over the values. Check the attachment.
HI,
For this you have to select SALES in the SOURCE field. You can use triggers to make this selection.
Regards,
jagan.
Check this out, jagan also suggested it
Added trigger on field WEEK, both onselect and onchange.