Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III
‎2014-03-30 02:37 AM

Creating System Monitoring App

Hi,

I am tring to make a basic system monitoring app. That should have following attribute

1. Load time calculation for different different tables

2. RAM Uses during reloading

3. CPU Uses during reloading

4. A trend line for RAM and CPU uses in a chart. time is in dimension.

I have developed a application but I am not able to show trend line . I am attaching my file please have a look on that and please update.

720 Views
0 Likes
8 Replies
whiteline
Master II
Master II
‎2014-03-30 05:04 AM

Hi.

It seems that you've uploaded the sample with some wrong data structure.

388 Views
agni_gold
Specialist III
Specialist III
‎2014-03-30 05:26 AM
Author

In response to whiteline

No actully i have loaded the data from QVD and Database both and i want to calculate the consumed time during loading . Main Question is how to show the CPU uses chard and RAM uses chart during reload .

388 Views
0 Likes
whiteline
Master II
Master II
‎2014-03-30 05:28 AM

In response to agni_gold

You have two separate tables with strange field names that are supposed to be connected.

388 Views
0 Likes
agni_gold
Specialist III
Specialist III
‎2014-03-30 05:55 AM
Author

In response to whiteline

sorry for that let me clear

I have a table in database having huge records so what i have done i just loaded that table in first tab  and in second tab  i have loaded the QVD of same data which i have made previously .

Now i am comparing the time of loading.

in first tab i have taken 2 variable at starting and at end so that it will calculate the time of loading

similarly in second tab and so on .

now when i reload this application reload time is calculated.

simultaneously i want to show the ram uses and cpu uses as in chart in dashboard after reload  , so how can i do this

388 Views
0 Likes
whiteline
Master II
Master II
‎2014-03-30 05:59 AM

In response to agni_gold

If you have RAM and CPU statistic you have to gather it and then load.

There is no build in tools for that.

Use some monitoring system tool that is able to be managed from QV macro and to store the result in a proper format.

388 Views
0 Likes
agni_gold
Specialist III
Specialist III
‎2014-03-30 06:07 AM
Author

In response to whiteline

Can i plot the chart from memory statistics, but this memory statistics can be generated manualy from document properties.is it possible to generate memory statistics automatically?

388 Views
0 Likes
whiteline
Master II
Master II
‎2014-03-30 01:02 PM

In response to agni_gold

Hi.

There is API that you can use from macro.

Search for API Guide qvw.

388 Views
0 Likes
Colin-Albert
MVP
MVP
‎2014-03-30 01:46 PM

Have a look at this thread.New version of Qlikview Cookbook

388 Views
0 Likes