topic Re: Table Chart Question in QlikView

Table Chart Question

mphekin12 — Wed, 25 Sep 2013 15:43:20 GMT

Hello,

I was wondering if there is any way to set a dimension in a Table Chart as unselectable to a user. For example, if I had an Area dimension that had the values North, South, West and East in it, usually if a user clicks on North, the chart will refresh with only data that is associated with the North area. Is there any way to disable this functionality so that when the user clicks on the Area nothing happens?

Any information would be grealy appreciated!

Re: Table Chart Question

Anonymous — Wed, 25 Sep 2013 15:48:57 GMT

Have you try the Read Only option in the General tab?

Re: Table Chart Question

mphekin12 — Wed, 25 Sep 2013 15:53:32 GMT

Jean-Luc,

Thank you for your suggestion. That works for the whole Table Chart. I have four dimensions and I only want two of them to be read only. Any other ideas?

Re: Table Chart Question

israrkhan — Wed, 25 Sep 2013 16:07:29 GMT

use set analysis to ignore the dimension, is this not suitable for your requirement,like below:

=sum(${<Area= >}Sale), so Area selections will be discarded, will take all area...

Re: Table Chart Question

mphekin12 — Wed, 25 Sep 2013 16:17:05 GMT

IsrarKhan,

Thanks for your response but that isn't going to work for me in this case.

Re: Table Chart Question

abeyphilip — Wed, 25 Sep 2013 16:31:59 GMT

Hi,

There is a workaround, create a text box of same size as your dimension column and place it over the dimension.

Make it "100%" in transparency and in Layout - make layer to "top".

May be there other ways to do this..

Regards,

Abey

Re: Table Chart Question

mphekin12 — Wed, 25 Sep 2013 16:48:41 GMT

Abey,

Thanks for the reply. I have used that method in the past. I was just hoping there was a property somewhere within the chart that I was missing that would allow me to do what I need to without the need for extra work arounds.

Re: Table Chart Question

rodrigo_damas — Wed, 25 Sep 2013 17:52:25 GMT

I've created an example with IsrarKhan's suggestion, and it worked for me.

Take a look!

Re: Table Chart Question

mphekin12 — Thu, 26 Sep 2013 12:59:41 GMT

Rodrigo,

Thank you for your example. It's a good suggestion, but unfortunately it will not work for me in this case.

Re: Table Chart Question

flipside — Thu, 26 Sep 2013 13:22:18 GMT

This might work, not fully tested though.

Use a field trigger on the dimensions which then clears that field. You would need to set up dummy fields so that the fields can be selected in other areas, so your dataload might look something like ...

data:

load region, region as regionDummy, sales inline [

region, sales

north, 1500

south, 2000

east, 500

west, 3000];

... and in your chart use the Dummy field for your dimension and add a trigger to clear the same field OnSelect.

flipside

EDIT: Maybe just use 'Back' as the Action will suffice!

Re: Table Chart Question

christian77 — Thu, 26 Sep 2013 13:24:56 GMT

Hi:

Unfortunately, sometimes we can't do what we have on mind. It's very difficult to filter and not to filter at the same time. I've just made an example of what IsrarKhan have said. It does not work. It does not filter by any dimension. I saw it as the correct answer but it is not.

Good luck.

Re: Table Chart Question

struniger — Thu, 26 Sep 2013 13:33:40 GMT

How about a trigger that clears the selection on this dimension?

It just means that in the entire application you can't do any selections on that dimension.

Re: Table Chart Question

Anonymous — Thu, 26 Sep 2013 13:42:36 GMT

may be you can use the lock field option in document properties.

Re: Table Chart Question

rodrigo_damas — Thu, 26 Sep 2013 13:44:19 GMT

This is for the entire application or just for an especific chart?

If it is for the entire application, you can put an action in the Area field that everytime you select Area, it will clear the field Area. So, anytime you try to select an Area it will clear the area selection.

To do this you go:

Settings>>Document Properties >> Triggers >> On Field Event Triggers, you may Add Action(s) On Select in the field you want to disable >> Add >> Selection >> Clear Field >> OK >> Put in the Field box, the name of the field you want to clear, in this case, Area.

I hope it helps.

Re: Table Chart Question

DavidFoster1 — Thu, 26 Sep 2013 13:45:42 GMT

I think you are fighting against the fundamental behaviour of the table chart.

Re: Table Chart Question

nizamsha — Thu, 26 Sep 2013 13:47:01 GMT

PFA

Re: Table Chart Question

mphekin12 — Thu, 26 Sep 2013 15:41:46 GMT

David,

I agree with you 100% percent. Unfortunately the customer doesn't see it that way.