topic Re: listbox: values possible to select in QlikView

listbox: values possible to select

Anonymous — Sat, 28 Mar 2015 23:24:15 GMT

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

Re: listbox: values possible to select

robert_mika — Sun, 29 Mar 2015 22:58:22 GMT

Try this link:

color changes for default selection

Re: listbox: values possible to select

Anonymous — Mon, 30 Mar 2015 18:34:17 GMT

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?

Re: listbox: values possible to select

oknotsen — Mon, 30 Mar 2015 22:24:57 GMT

What is the actual functionality you are looking for?

In other words:

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

Re: listbox: values possible to select

ramoncova06 — Mon, 30 Mar 2015 23:31:30 GMT

have you checked with alternate state

what is alternate states in Qlikview ?

Re: listbox: values possible to select

Anonymous — Tue, 31 Mar 2015 07:54:35 GMT

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

Re: listbox: values possible to select

oknotsen — Tue, 31 Mar 2015 08:05:50 GMT

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.

Re: listbox: values possible to select

Anonymous — Tue, 31 Mar 2015 08:23:07 GMT

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".

Re: listbox: values possible to select

Anonymous — Wed, 01 Apr 2015 13:45:57 GMT

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

Re: listbox: values possible to select

ramoncova06 — Wed, 01 Apr 2015 14:49:25 GMT

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)

Re: listbox: values possible to select

Anonymous — Wed, 01 Apr 2015 21:20:19 GMT

Thanks, everyone, for your comments!

I'll try your advice a bit later.

Re: listbox: values possible to select

Anonymous — Thu, 02 Apr 2015 10:12:35 GMT

Hi,

I tried this approach. But it doesn't seem work the way I need.

E.g. there are 24 months in my data, but brand 'BYD' is available on 3 months only.

Step1: I set =aggr(only({<Brand = $::Brand,Month = $::Month>} Month),Month) for check box Month.

Step2: I select brand 'BYD'.

Step3: I see only 3 months available in check box Month. Others disappeared.

My task is not to let Months disappear. They all must be present.

For some reasons Brand and Month must have the same alternate state.

Please see the file attached.

Is there any solution?