Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

listbox: values possible to select

Hi,

Generally QlikView marks values impossible to selects in a listbox by a grey colour.

So there are white values possible to select and grey values.

I don't need values to become grey on condition they are not possible to select.

So how can I tune a listbox so that it could display all values not making some of them grey?

Thank you in advance,

Larisa

11 Replies
robert_mika
Master III
Master III

Anonymous
Not applicable
Author

Yes, I know about extensions. I meant not only changing the colour but also making such a listbox where all values are always possible to select no matter what is currently selected.

Is it possible to create an independent listbox where all values are always possible to selected?

oknotsen
Master III
Master III

What is the actual functionality you are looking for?

In other words:

What is the problem (or Use Case) you are trying to solve?

May you live in interesting times!
ramoncova06
Partner - Specialist III
Partner - Specialist III

have you checked with alternate state

what is alternate states in Qlikview ?

Anonymous
Not applicable
Author

Hi,

The task I'm solving is as follows:

There are two checkboxes in my model: Brand1 (alternate state = S1) and Brand2 (alternate state = S2). They are based on the same field byt have different states.

There is also a checkbox Month (alternate state = S1).

I have a trigger action on select in checkbox Month. This action automatically transfers selected Months from state 1 to state 2. So, months dimension works for brands selected in checkbox Brand1 and Brand2.


If there is a selection in checkbox Brand1 (S1), then some months become impossible to select in checkbox Month (S1). But it doesn't suit me because there is also checkbox Brands2 (S2).


I'd like any month to be always possible to select.


How is that possible?


Larisa

oknotsen
Master III
Master III

Still sounds like you are explaining a technical solution that you already have in mind (no offence intended).

My question is:

What is the customer problem behind it?

Currently it sounds to me like you are trying to achieve something which simple doesn't work that way in QlikView, so if we would know what the problem of the customer is (and with that I do not mean the technical solution you are currently thinking of), maybe we can offer you an alternative technical solution for it.

May you live in interesting times!
Anonymous
Not applicable
Author

Hi

This might be possible to do when we have expressions involved but I have not been able to get listboxes to "ignore" the Alternate states. For example if i wanted an expression to belong to a specific state i could use something like this sum({[Group 1]<Region = $::Region, [Sales Rep] = $::[Sales Rep], Path = $::Path, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} Sales) This would Sum Sales for the state it belongs to but would also follow selections made outside of the state that are listed in the expression. So int the case Region = $::Region I could still make selections in this field and they would also be made for the expression. However if any selection was made in a field not in the "list" that would not effect the calculation.

In you case I would like to have State1 and State2 be controlled by the selection in the checkbox Month (you could always create a new Month field in your script if you don't want to use the actual month Field). I have not yet been able to do this for a single field/dimension (only expressions).

if you want to see how this is used you can check out the demo app "what's new in QlikView 11" this should be available under your "getting started option". This is used on tab "Product Grouping" and "Sales Overlap".

Anonymous
Not applicable
Author

Hi,

I'll try to explain form another angle.

There are 2 listboxes: Brand (there's a setting = always one selected) and Month.

It's important to say that Brand A is present in January only.

Let's say that Brand A is now selected. A user clicks on February but February can't be selected.

Is it possible to tune QlikView so that February could be selected in this case?

What result do I need? We have Brand A selected and also January+February selected. Then we have a chart with dynamics. We can see a nonZero value in January and a zero value in February.

Thank you in advance,

Larisa

ramoncova06
Partner - Specialist III
Partner - Specialist III

Nils is into something here.

open the listbox and add an aggr expression that excludes the selection of that field 

aggr(only({[Group 1]<Region = $::Region, [Sales Rep] = $::[Sales Rep], Path = $::Path, Year = $::Year, Quarter = $::Quarter,Month = $::Month>} Month),Month)