topic Re: Limiting the data displaying in chart in QlikView

Limiting the data displaying in chart

Anonymous — Fri, 20 Nov 2015 17:57:57 GMT

Hello Experts,

I need some help in limiting the data in the charts. I created a straight table chart.When the user opens the document in access point the straight table will load 2 million records. Is there a way that when the user opens the report every time in access point it would have the data for just a month by default and after which the user can make their own selections?

Any help would be highly appreciated..

Thanks

Heera

Re: Limiting the data displaying in chart

swuehl — Fri, 20 Nov 2015 18:16:36 GMT

If the users opens the QVW using the IE plugin, you can use an OnOpen trigger with Select - Select in field action to select the month.

Re: Limiting the data displaying in chart

Anonymous — Fri, 20 Nov 2015 18:20:04 GMT

Thank you for the quick reply. I did try the solution you have suggested, but what if the user is on Ajax Plugin?

Thanks

Heera

Re: Limiting the data displaying in chart

Anonymous — Fri, 20 Nov 2015 18:33:32 GMT

How is it going to be for Ajax Plugin

Re: Limiting the data displaying in chart

Mark_Little — Fri, 20 Nov 2015 18:37:42 GMT

HI,

The above approach would be the quickest method. you can find the option in

Settings > document properities > Triggers.

In the top select OnOpen.

Another option is to set the fields to have always have one selected, on the year and month field.

Another option is to set the table to have calculated condition, where it only calculates when > x amount of rows returned and give a error please make a selection?

Mark

Re: Limiting the data displaying in chart

Anonymous — Fri, 20 Nov 2015 18:45:50 GMT

Mark,

I have read somewhere that Ajax Plugin wont support triggers, in that case how can we have that triggers in Ajax plugin. I have used you suggestion of having calculating condition for the chart and its working.

Thanks....

Heera