Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Table & Field Statistics

HI All,

How to read statistics of any fields from my data ? I want to generate a report to show statistics of each field available in data. Statistics like count, occurrences , length etc..

8 Replies
sunny_talwar

May be you can use Document Analyzer Application by Rob which gives good information. You can find document analyzer here: Tools | Qlikview Cookbook

Best,

Sunny

tamilarasu
Champion
Champion

Check out the below link.

QlikView App - Generic Data Profiler

Hope this is what you need.

scriptina.jpg

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

Data Profiler gives me the exact information, but each time i have to select field to get the information.

Would like make it in a single table , so it can be exportable as report.

vardhancse
Specialist III
Specialist III

Hi,

We can export memory statistics from our dashboard.

Settings->Document settings->Memory statistics(Button)

This we can export .mem file.

Once exported we can reload to another QVW and we can see complete statistics of dashboard like number of objects, memory occupied and all.

Or else

In governance dashboard also we can see all the required statistics

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

I am not looking at mem statistics. This will be used to understand the data and its availability before starting qlikview development.

vardhancse
Specialist III
Specialist III

Mem statistics exported from dashboard are useful after development of dashboard

tamilarasu
Champion
Champion

Check the attachment. You can add/modify your etc's in the chart. cheerful-cat-face-smiley-emoticon.gif

Let me know If it's fine for you.

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

Hi Nagraj,

All of your rows show the same information. Looks something wrong..