topic Re: Qlikview model keeps crashing in QlikView

Qlikview model keeps crashing

Anonymous — Mon, 30 Jul 2018 13:24:43 GMT

Hi all

I have a Qlikview model which I have created. it is 500MB big. The model consists of 3 tables. Table one = 500k rows (13 variables)

Table two = 82 million rows (14 variables), Table 3 = 10 million rows (5 variables ).

All of the tables are QVD's stored on the client computer.

The tables take 40 seconds to load. The model has 2 tabs. The first tab has 5 graphs with 4 filters available.

Now when I try to create table graphs on the second tab Qlikview crashed all the time.

I have more than enough RAM (64GB) with Qlikview opened there's on average there's only 6GB in use and 10% CPU usage.

The model has no synthetic keys.

I am Qlikview 12 and I'm opening the file in server.

What would I need to check or change to prevent Qlikview from crashing every time I try working on this report?

Re: Qlikview model keeps crashing

felipedl — Mon, 30 Jul 2018 18:27:58 GMT

Might be due to the gigantic amount of data your trying to get from table two (82 million rows) with all the columns your trying to put in the table.

Can also be a bad relationship between the fields you put on the table, since it might be that they aren't connected and if you put fields that aren't related in the data model Qlik will make a "join" on the visualization side, expanding the data even further.

Re: Qlikview model keeps crashing

vishsaggi — Mon, 30 Jul 2018 19:54:26 GMT

Is it failing when you create a table or during navigation to different sheet tab?

Re: Qlikview model keeps crashing

Anonymous — Tue, 31 Jul 2018 07:22:52 GMT

The tables are linked on a common variable. One is a sales table, one is a leads table , and the is a customers table which holds customer information. They all have a Party_ID that identifies the customer and that is used to link the tables. The party_ID is the most granular level of detail on all the tables.

Re: Qlikview model keeps crashing

Anonymous — Tue, 31 Jul 2018 07:24:50 GMT

The report has 2 tabs so far the first tab has 4 graphs when I try adding a graph on the second tab that's when Qlikview fails. Navigating between the tabs in not a problem.

Re: Qlikview model keeps crashing

vishsaggi — Tue, 31 Jul 2018 15:35:20 GMT

In your current app before adding any additional chart objects can you check the memory and calc time of those added objects from Document properties. Like Click Ctrl+Alt+D to open doc properties and go to sheets tab and look in the bottom table for Calc time and Memory and other columns send us a screen shot if possible?

Re: Qlikview model keeps crashing

Anonymous — Wed, 01 Aug 2018 07:01:14 GMT

Hi Vishwarath, i have please see attached the screen shots Calc Time and Memory

Re: Qlikview model keeps crashing

BalaBhaskar_Qlik — Wed, 01 Aug 2018 07:46:17 GMT

What are the Dimensions you are using in your 2nd tab, Table graphs?

May be the Granularity between different tables causing the issue.

Re: Qlikview model keeps crashing

Anonymous — Wed, 01 Aug 2018 15:07:09 GMT

The second graph (bar graph) which im trying to add is meant to show data from the same table. The expression sums up a variable and shows it along a dimension variable that is on the same table. This table has 500K rows.

Re: Qlikview model keeps crashing

vishsaggi — Wed, 01 Aug 2018 15:28:50 GMT

Can you share your variable expression you are using? Also can you upload your file if possible?

Re: Qlikview model keeps crashing

Anonymous — Thu, 02 Aug 2018 07:28:11 GMT

the expression is SUM(Sales)

Re: Qlikview model keeps crashing

Anonymous — Thu, 02 Aug 2018 07:40:22 GMT

Please attached the file I am using. I have uploaded it without the data.

The expression I am creating is a simple SUM(SALES) expression.

On tap 2 there is already a chart that I have created which does a calculation using data from the two tables SUM(SALES)/SUM(LEADS), I was able to create the first chart graph, it is only when I'm trying to create the second graph that the application crashed.

Regards

Re: Qlikview model keeps crashing

vishsaggi — Thu, 02 Aug 2018 12:22:16 GMT

Will look into it.

Re: Qlikview model keeps crashing

vishsaggi — Thu, 02 Aug 2018 14:06:54 GMT

I dont see any data model nor data in your attached file. Can you re-upload. ?

Re: Qlikview model keeps crashing

Anonymous — Mon, 13 Aug 2018 07:27:24 GMT

if i load the data the file will be 1GB and the data is sensitive so i cannot share it. Is there a way around this?

Re: Qlikview model keeps crashing

Or — Mon, 13 Aug 2018 07:46:34 GMT

Just a quick question here - can you try and reproduce the problem with a more recent version of QlikView? You seem to be using a relatively old version (11.2 SR15) whereas the most recent version of 11.2 is SR17 and the most recent version of QlikView is 12.2 SR6. I doubt it'd help, but it might be a good idea to try the most recent version just to make sure the problem isn't caused by a bug that's been resolved.

Insofar as testing the issue - try reducing the dataset (only loading the top N rows, or making selections and then reducing data to possible values). That should help you debug.

Re: Qlikview model keeps crashing

marcus_sommer — Mon, 13 Aug 2018 09:03:41 GMT

I could imagine that your key between your tables isn't really suitable. You said the key represents the customer but if you want for example to use any date/product dimensions or something similar within your objects the customer-key won't connect the dimensions respectively granularity properly. Beside wrong results it might lead to the creation of large cartesian tables - behind each calculation is a temporary table on which the calculation is performed - which might cause your problem.

To get further you could reduce the number of records (maybe within the debugger or with some FIRST prefixes for the loadings) and/or applying some selections within your application before creating/changing your objects. Both measure will reduce the used dataset for all the background-calculations and should minimize the risk of a crash and you could check if your data and logic returned the expected results.

- Marcus