topic Re: Tables in QlikView

Tables

Mon, 12 May 2014 09:48:21 GMT

Hi all,

How does it come Qlikview refreshes all my tables/charts etc when I make a selection in one of my tables.

Like when I go from Divsion -> Weeks in a pivot table it starts reloading my other charts/tables.

Why does Qlikview do this and is it possible to de-activate this?

kind regards,

Vincent

Re: Tables

ashfaq_haseeb — Mon, 12 May 2014 09:52:41 GMT

Hi,

This is because of the default qlikview behavior.

Loading/reloading or calculating time depends on the type of calculations you have in your front end.

Try to avoid using distinct counts/sum

hope it helped.

Regards

ASHFAQ

Re: Tables

Mon, 12 May 2014 09:54:52 GMT

put count distinct in my script?

Re: Tables

hic — Mon, 12 May 2014 10:05:42 GMT

This is the very core of QlikView: Every time you make a selection, QlikView re-calculates everything. And that is the purpose of making selections. It does not help to use Count(distinct ...).

Read this: http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/15/logical-inference-and-aggregations

HIC

Re: Tables

jsingh71 — Mon, 12 May 2014 10:37:55 GMT

If you want to other charts was not get updated then go to chart properties and select Read only check box under general tab.

--Jai

Re: Tables

Mon, 12 May 2014 10:56:39 GMT

I know it recalculates when i make a selection but im just down drilling in a pivot table.

Example:

Divsion X i press the + icon so it will open weeks.

WIthout selecting weeks or divsion Qlikview still starts recalculating. Same then when I did not select anything for a min and then click an other tab or the same I open ( + ) it starts reloading all my tables.