topic Re: Chart vs. Table box in QlikView

Chart vs. Table box

Sun, 08 Jul 2012 09:50:05 GMT

Here is a question:

When I create a table box in a page, I can select how the selection will look like, i.e. LED check box, window check box and etc.

With this object, when the user makes a selection, all non-selected values are grayed out but can still be selected with a simple click.

When I create a chart object (straight table for that matter), I don’t have that option. Meaning, if a user makes a selection, all other values are disappeared and he can’t do a multiple selection (unless drag over a range of values).

How can I allow the user to have multiple selections that are not adjacent to one another within a chart object?

Re: Chart vs. Table box

kji — Sun, 08 Jul 2012 10:02:48 GMT

If you enable "Show All Values" on your dimension, and disable "Suppress Zero-Values" / "Suppress Missing" you will still see the deselected values in your Straight Table/Chart.

Re: Chart vs. Table box

Sun, 08 Jul 2012 10:08:58 GMT

hi Johan,

actually thats what i did.

the result is that it shows the selected value / values and all the zero values.

but it doesnt show nonzero non selected values.

any other ideas? because at this point i have no more supressiones to uncheck.....

Re: Chart vs. Table box

Sun, 08 Jul 2012 10:10:35 GMT

oh and also,

it still doesnt allow me to do multi-select.

so maybe im missing somthing here?

Re: Chart vs. Table box

pljsoftware — Sun, 08 Jul 2012 10:38:39 GMT

Hi Elanir,

I did not understand, you want to select more value not adjacent from a fild box?

Try to use CTRL and select more elements.

Or you want to see too the elements not selected?

Regards

Luca Jonathan Panetta

PLJ Software

Re: Chart vs. Table box

Sun, 08 Jul 2012 11:01:04 GMT

Luca,

its very simple.

in a table box one can select multiple values by selecting a range of values or by using CTRL as you mentioned.

in chart objects (straight table) you can only select multiple values by selecting a range of values.

but you cant select multiple values by using CTRL.

im looking for a solution that will allow me to do that.... any ideas?

Re: Chart vs. Table box

pljsoftware — Sun, 08 Jul 2012 11:27:41 GMT

Hi Elanir,

but why can't you use a fild fileter external of the chart (eg. pivot table).

In you sheet you have a filter (eg. Customers) and a chart (eg. Pivot table).

So you can use the external filter to choise your data in this example Customers.

And if you have more filters you can group they in a Group Box, I use this technical to reduce the space of elements in my sheets.

I hope this help you.

Regards

Luca Jonathan Panetta

PLJ Software

Re: Chart vs. Table box

Sun, 08 Jul 2012 11:49:02 GMT

Luca,

i also do that many times.

but in this case, the user, if i use your example, has the customer dimension in a table box, and than again this dimension appears in that same sheet in a chart object with same dimension but with different calculations.

the user now want to select a group of customers according to performance, not as a range of values but by selecting specific unique values by using CTRL.

and i dont understand why this cant be doen within a chart.....

Re: Chart vs. Table box

pljsoftware — Sun, 08 Jul 2012 14:02:46 GMT

Elanir,

can you add an example QVW of your application or an screenshot?

Regards

Luca Jonathan Panetta

PLJ Software

Re: Chart vs. Table box

Sun, 08 Jul 2012 14:19:41 GMT

this is how the dashboard looks like: (without the black marks )

as you can see, i have a table box on the left side to allow selection of multiple values from a dimension.

also in main area, user has that same dimension with all its relevant expressiones.

as i said before, if the user wants to select a number of un-adjacent values from main area by using CTRL, he cant do it.

he can only select a range of adjacent values - not exactly what im looking for.

any ideas?

Re: Chart vs. Table box

pljsoftware — Sun, 08 Jul 2012 15:14:59 GMT

But why and user must to select not continue values directly in a chart when he have the filters?

If the user want to select the data not continue can use the filters.

I think that your problems don't have solution.

Regards

Luca Jonathan Panetta

PLJ Software

Re: Chart vs. Table box

MayilVahanan — Mon, 09 Jul 2012 19:37:17 GMT

Hi,

Try this,

Properties -> Presentation ->Select dimension from columns and tick dropdown select..

So from drop down , you can select more than one value in straight table .

Hope it helps

Re: Chart vs. Table box

pljsoftware — Fri, 13 Jul 2012 09:57:00 GMT

Try this.

Regards

Luca Jonathan Panetta

PLJ Software