topic selection in chart in QlikView

selection in chart

Thu, 13 May 2010 05:59:15 GMT

if I click on any field in chart… the chart should not filter/shrink on that value instead it should take the values of selected row and show in current selections or in list boxes.

For example if I click on company "A" (5^th row), the chart should remain same (like detach) but and in the list boxes/ current selection the values are like

selection in chart

villafuerte — Thu, 13 May 2010 14:03:04 GMT

Hello,

If you want an object (for example a Straight Table or a Chart) to stay fixed with all the information you can use Set Analysis, but instead of using {$}, use {1} so that it always selects the whole set.

If you want it fixed but with certain information, you can also specify it in the Set Analysis part.

Hope it helps!

selection in chart

Thu, 13 May 2010 15:12:24 GMT

Thanks, can you please upload an example....

selection in chart

Thu, 13 May 2010 16:10:26 GMT

In my straight table there is expression Sum(Sales) to find out the total sales. instead of that ,if i use Sum({1}(Sales)), all the data will be displayed as such even if you select data on list box. Reason for that is,{ 1} - Represents the full set of all the records in the application

selection in chart

Thu, 13 May 2010 16:12:33 GMT

I have attached the example ,I have done ..please try this...

selection in chart

villafuerte — Thu, 13 May 2010 16:22:37 GMT

Hello,

I made a simple example for you. It contains a normal table and then the one with Set Analyisis so you can check the differences.

I hope it helps !

selection in chart

Thu, 13 May 2010 20:50:24 GMT

Thank you very much... Villafuerte & naive123 for your examples, its working fine but its not completely solves my problem, also looking for

If I click on ASK Price, True Cost,..... etc...(in my example) its working good, but when I click on status or country or company (dimensions) its not.. as I showed in my example if I click on Company : - "A" in 5th row then the filters (list boxes) should show only Active & Chile not all Hold-qty or cube...as I clicked "A" from country Chile and status is Active.. (marked in red in my example).
I should be able to filter the chart from list boxes.
also I have filter on numeric columns in my chart where I can filter on range ex: - >=5 <=10..

Thanks in Advance

selection in chart

Fri, 14 May 2010 07:50:17 GMT

Can you please post the application? so we will better understand your requirements......................

selection in chart

villafuerte — Fri, 14 May 2010 14:17:50 GMT

Hi,

I hope we can help you with your problem, but can you make a dummy file so we can understand it better please?

Cheers