topic Re: Listbox Selections in QlikView

Listbox Selections

Fri, 05 Feb 2016 21:52:28 GMT

Hi,

In the attached sample file, I have 2 listboxes with 2 different fields - MonthCurrent and MonthProjected. I want to allow user to select months from both the listboxes simultaneously and the sales amount should be calculated accordingly, but its not working right now. Is this possible without using alternate states?

Re: Listbox Selections

swuehl — Fri, 05 Feb 2016 22:55:05 GMT

Maybe like attached

Re: Listbox Selections

Fri, 05 Feb 2016 23:30:16 GMT

Hi Swuehl,

Thanks for your reply. I am aware of this option. However, I do not want to change the data model. Since there are many other dimension tables in my actual data model. If I split the fact table into 2 fact tables - one for current and one for projected, this would create circular loops since both fact tables would have to be connected to all the remaining dimension tables. Is it possible to do this without changing the data model?

Thanks.

Re: Listbox Selections

sunny_talwar — Fri, 05 Feb 2016 23:37:59 GMT

Is there a particular reason why you don't want to use Alternate State? I feel that was the best solution, but you are not wanting to use it?

Re: Listbox Selections

swuehl — Fri, 05 Feb 2016 23:42:39 GMT

It's hard to advise a model without knowing the full requirements.

I am pretty confident that you can keep the two fact tables and link them with a key, and create another table with this key and all your common dimension.

In general, if you want to make indepent selections e.g. on field date, it's easier to have these date fields in separated tables, linked by a key field. If both fields reside in the same table, any selection will limit the records (this is what you have observed already). You can try to workaround this with data islands / alternate states and set analysis, but you don't like this option neither.

Re: Listbox Selections

Sat, 06 Feb 2016 06:58:35 GMT

Hi Sunny,

Alternate states is working fine. However, since all my other listbox objects or objects without formula in the dashboard holds the regular inherited states, the alternate states listboxes would not work for them. Hence, I am trying for solution without requiring alternate states if possible. If there is no other way, I will use alternate states.

Thanks!

Re: Listbox Selections

Sat, 06 Feb 2016 07:00:41 GMT

Thanks Swuehl! I will try with 2 fact tables and see if there are any circular loops. If there are none, I will use this approach. Thanks again!

Re: Listbox Selections

Mon, 08 Feb 2016 19:30:21 GMT

Hi Swuehl.

Though there are no circular loops in my data model after adding 2 fact tables, connecting the 2 fact tables does not allow to select both the fields simultaneously. See attached.

Thanks,

Sheetal.

Re: Listbox Selections

swuehl — Mon, 08 Feb 2016 19:58:47 GMT

Your table should be linked by a key field, e.g. Customer, Article etc.

If you don't have a key, just create an artifical one.

You are linking your two tables using your sales facts, which is not what you want.

Re: Listbox Selections

MarcoWedel — Mon, 08 Feb 2016 23:34:37 GMT

please post some examples of selections in both fields and your expected result.

thanks

regards

Marco