topic Re: Strange behaviour in QlikView

Strange behaviour

sunilkumarqv — Thu, 02 Jul 2015 07:27:00 GMT

Hi friends

Strange behaviour in my chart objects taking long time to load if anyone faced these situation & solved

Plz help me on these regard

Re: Strange behaviour

Thu, 02 Jul 2015 07:30:30 GMT

Can you post what is the expressions and dimensions used in the chart? It will help to find the problem.

Re: Strange behaviour

sunilkumarqv — Thu, 02 Jul 2015 07:31:53 GMT

nothing much complicated simple expressions as i do same in earlier projects

Re: Strange behaviour

MK_QSL — Thu, 02 Jul 2015 08:16:56 GMT

1) could be because of Cartesian Join in your Data Model....

2) Could be improper data model. Can you reload the application with limited load and check is there any Synthetic Key or not.

Re: Strange behaviour

Thu, 02 Jul 2015 08:23:32 GMT

Hi Sunil

Such problem is arise only if our data modeling is not correct or maybe the use of joins is improper.

Hope it helps

Regards

Ahmed

Re: Strange behaviour

jagan — Thu, 02 Jul 2015 08:32:18 GMT

Hi Sunil,

If you have huge data, if you have less RAM in your PC, if your datamodel has any issues, if you are using complex expressions then you will get this kind of issues. If you attach sample file then it would be easier.

Regards,

Jagan.

Re: Strange behaviour

sunilkumarqv — Thu, 02 Jul 2015 09:47:29 GMT

HI manish

There is no any Cartesian Join in Data Model. In fact used link table concept

Hi @jagan mohan

my qlikview application was 44 MB ,used simple calculated conditions and my ram processing also well enough

Re: Strange behaviour

Siva_Sankar — Thu, 02 Jul 2015 09:57:03 GMT

Sunil,

To narrow down the issue go to the sheet properties by pressing Ctrl +Alt + S together. Once you are in sheet properties, check the calc time and memory