topic Need Solution?? in QlikView

Need Solution??

aveeeeeee7en — Sun, 27 Apr 2014 12:30:26 GMT

Hi All

I have 2 Tables: one is Main Table and other is Reference Table.

1) The difference between Main Table & Reference Table is :

Main Table is created from Script whereas Reference Table is created from Front end using Expressions.

2) I need the same Result which is showing in "Reference Table" when selecting NEWDIVISION eg. "IT DIVISION" in "Main Table".

3) The Problem with "Main Table" is when I am making Selections, the Data is not changing since I have used Cumulative Sum.

Is there any way to show the Same result in "Main Table" as it is coming from "Reference Table" while doing NEWDIVISION Selections.

Regards

Aviral

Re: Need Solution??

Sun, 27 Apr 2014 21:35:23 GMT

Aviral,

I'am afraid, that you should better clarify your needs. I read your post few times and had a look on your exaple and still don't know what you really need

Defining your data model you should plan data granularity. In general QlikView with its associative data engine gives you possibilities to load detailed data and calculate KPI's on the fly regarding user selections. Having data in-memory, calculations should be very fast.

Of course sometimes it is worth to calculate some aggregates during reload and use it in your application, when you know that those aggregates are used often, for example on high level dashboard.

Remember, that approach with cube, where you calculate results during reload doesnt have sense here. QlikView de facto is doing it by storing results in cache, and developer doesn't need to care about it. In bigger apps RAM used by cache may be few times larger than RAM used by loaded data.

regards

Darek

Re: Need Solution??

aveeeeeee7en — Mon, 28 Apr 2014 00:51:50 GMT

Thanks Dariusz for the Reply.

Actually, I want the Data in Main Table to get changed on Field Selection(NEWDIVISION).

Due to wriiten Code, the Data is Freezed and is not changing.

Regards

Aviral

Re: Need Solution??

dinuwanbr — Mon, 28 Apr 2014 03:46:04 GMT

Hi there,

Any how you locked the NEWDIVISION field. That's why you cant change the values. I'm looking into your problem and upto now you can override the lock.

NEWDIVISION--> Properties--> General --> Check Override Locked Field.

hope this will be helpful.

BR,

Dinu1

Re: Need Solution??

dinuwanbr — Mon, 28 Apr 2014 03:49:16 GMT

Dear Aviral,

Just Right click on the field (NEWDIVISION) and unlock it.

That's it.

-Dinu1

Re: Need Solution??

aveeeeeee7en — Mon, 28 Apr 2014 03:52:33 GMT

Hi Tharindu,

It's not about the Lock/Unlock fields. I have Locked the field to show the sample case.

Kindly see the Requirement.