topic Re: Restrict data in chart and table in QlikView

Restrict data in chart and table

Anonymous — Thu, 29 Oct 2015 14:06:12 GMT

I am bringing in 1 table. I have two tab in the application. One needs to show group A data and the other group B data.

In one tab I have a chart listing column 1, 2, and 3 and the chart has an expression "IF group A" . The tab also has a table listing and currently it shows all A and B. I want it to show only group A like the chart.

The other tab has same as above but for group B.

Re: Restrict data in chart and table

settu_periasamy — Fri, 30 Oct 2015 02:54:53 GMT

Hi,

You can try to create one Button / On Activate Sheet Trigger

Select In Field -> Your Field (you already used for your chart ,"if Group A") ->

Search String (Entered your Filter Expression)

Then you will get the same data for your chart and Table

Re: Restrict data in chart and table

avinashelite — Fri, 30 Oct 2015 04:40:25 GMT

I didn't get the exact requirement, if you need to reduce the data then make you of the conditional statements according to your requirement , this should resolve the issue.

Please try to share the data or sample file so that it will be helpful for us to understand

Re: Restrict data in chart and table

jonathandienst — Fri, 30 Oct 2015 06:32:39 GMT

The charts in the respective tabs should include the group condition in set expressions:

Sum({<group = {A}>} Amount) for the chart on tab A

Sum({<group = {B}>} Amount) for the chart on tab B

Although I am not sure that this is the best design. If the charts and structure of the two groups is the same, why not just provide a list box for group and let the user choose the group? If necessary, hide or conditionally calculate the objects using the condition "GetSelectedCount(group) = 1" or something similar.

Re: Restrict data in chart and table

neha_sri — Fri, 30 Oct 2015 06:49:15 GMT

Hi,

What I can understand from your statement is you have data something like this:

Regards,

Neha

Re: Restrict data in chart and table

Fri, 30 Oct 2015 06:52:38 GMT

So you want to reduce the data, for that you can use alternative state. in tab1 you can use state1 fro chart1 and in tab2 state2 for same chart u can use.

Re: Restrict data in chart and table

Fri, 30 Oct 2015 06:55:27 GMT

So you want to reduce the data, for that you can use alternative state. in tab1 you can use state1 fro chart1 and in tab2 state2 for same chart u can use.

Re: Restrict data in chart and table

Anonymous — Fri, 30 Oct 2015 13:38:43 GMT

These are all good. This is what I have

Country Sales

A 6000

A 1500

B 2000

B 2500

B 9000

C 1500

In one tab,

I have a chart with the expression =if([Country] = 'A' or [Country] = 'C',Country)

This displays:

Country Sales

A 7500

C 1500

The data chart shows ALL (A, B, C) because I don't know how to limit the data to only A and C.

I tried using the sheet property Select In Field, but with this I can only have 1 value and I have 2 (A and C).

Re: Restrict data in chart and table

settu_periasamy — Fri, 30 Oct 2015 16:04:53 GMT

Hi,

Try to give your 2 values in search string..

Select in Field -> search string

('A'|'C')

Re: Restrict data in chart and table

Anonymous — Fri, 30 Oct 2015 21:02:27 GMT

I was able to add more than 1 value using the Select in Field --> Search String (A|C) . This worked.