topic Re: Help with QV Function Survey in QlikView

Help with QV Function Survey

rwunderlich — Tue, 14 Apr 2015 17:30:03 GMT

I was recently working with a customer developing training curriculum and the question was asked "what expression functions do most developers use". I thought it was a question worth getting a specific answer to. So I'm creating a community project to gather data on what QV functions and features people use.

Please help out by running the attached QVW against your installation's QVWs. The scanner will gather anonymous information and produce a QVD that should be emailed to me per the instructions in the file.

- The scanner runs fast -- about 60 QVWs per minute or better.

- The survey QVD contains only counts of function usage -- such as how many time sum() is used.

- No private information is included in the survey QVD that you return to me. There are no qvw names, no userids, no expressions no fieldnames or data.

- I will make the collected data freely available to the community for analysis.

- I prefer that you run against your production or QA, just to eliminate the extra copies and backups that appear in a dev environment. If you can't scan production, please go for the cleanest directories possible.

Why should you take the time to help me on this?

1. You may gain some insights from the data.

2. I help you out with free tools like Document Analyzer, QVPR Analysis and the QlikViewCookbook. Time to return the favor.

Thanks in advance,

-Rob

Updated scanner to scan contents of variables for Function names.

Updated scanner to include expressions in text objects.

Re: Help with QV Function Survey

Tue, 14 Apr 2015 17:59:41 GMT

Would love to help out with this ... analyzer running now and I can't wait to see the results.

How do you want us to get you the data?

Re: Help with QV Function Survey

Anonymous — Tue, 14 Apr 2015 18:58:25 GMT

Rob, great idea. But the reload chokes on me... First on an app with Venn chart, and I removed it, next on a file where I used bit operators, and again on something else. If I push through the qvd file is very small and contains each function exactly once...

I'll try later again, keeping only the "typical" QVWs.

Re: Help with QV Function Survey

rwunderlich — Tue, 14 Apr 2015 20:45:40 GMT

Michael,

When you say "choke", do you mean script error? Can you post the failing document log? (Just the 20 lines or so before the failure).

-Rob

Re: Help with QV Function Survey

Anonymous — Tue, 14 Apr 2015 22:05:17 GMT

Yes Rob, script error:

Looks like the "Expressions" table was never created. I'm attaching the end of the log file. You'll notice the "invalid character" error - there are dozens of them through the log...

If it doesn't help, I can email you the complete log file using the email address in your app.

Regards,

Michael

PS: It is old QV10. Maybe I have to try on 11.20?

Re: Help with QV Function Survey

Anonymous — Wed, 15 Apr 2015 13:15:23 GMT

Upgraded to QV 11.20 SR10 - works fine. I'll send the QVD shortly.

Edit: Sent

Re: Help with QV Function Survey

Wed, 15 Apr 2015 13:34:38 GMT

Worked fine for me without any issues.Version 11.20. SR8 64bit. Sent the QVD.

Thanks and Regards

Ram

Re: Help with QV Function Survey

rwunderlich — Wed, 15 Apr 2015 19:23:11 GMT

I need some translation help. What kind of sheet objects are these?

Swedish: Mosaikdiagram

Spanish: Objeto Marcador

Thanks,

Rob

Re: Help with QV Function Survey

rwunderlich — Thu, 16 Apr 2015 02:54:42 GMT

I've updated the scanner to look in variables for Function names as well. If you want to rescan and resubmit, feel free. If you don't it's probably not a big deal.

-Rob

Re: Help with QV Function Survey

rwunderlich — Mon, 20 Apr 2015 19:33:36 GMT

So far I've received 38 submissions from 15 countries, representing over 6,500 QVWs. More data is better! Is your country underrepresented? Bump up your numbers by downloading and running the survey scanner at the top of this thread now!

And why haven't I heard from India?

Argentina	1
Australia	1
Belgium	1
Canada	1
Croatia	1
Ireland	1
Italy	1
Netherlands	2
Norway	1
Romania	1
Spain	1
Sweden	3
Turkey	1
United Kingdom	2
United States	20

Thanks to everyone who has submitted so far!

Re: Help with QV Function Survey

rubenmarin — Mon, 20 Apr 2015 19:57:50 GMT

Hi Rob, I can help with the spanish translation

Objeto Marcador = Bookmark object

Re: Help with QV Function Survey

rwunderlich — Mon, 20 Apr 2015 20:08:25 GMT

Thanks Ruben!

-Rob

Re: Help with QV Function Survey

michael123 — Tue, 21 Apr 2015 11:05:52 GMT

Mosaikdiagram (Swedish) = Mekko chart.

/Michael

Re: Help with QV Function Survey

rwunderlich — Tue, 21 Apr 2015 16:25:14 GMT

India has checked in! (Although I know there are more QV Customers there....). Italy is making a strong showing.

Argentina	1
Australia	1
Belgium	1
Canada	1
Croatia	1
India	1
Ireland	1
Italy	3
Netherlands	2
Norway	1
Poland	1
Romania	1
Spain	2
Sweden	3
Turkey	1
United Kingdom	4
United States	21

Some interesting preliminary results:

You might have guessed that sum() is the number #1 used function. What function do you think is #2?

Text Object and List Box are the number #1 & #2 most used objects. What object is #3?

More data! More data! Please submit if you haven't done so already, Remember that:

- Only anonymous data is collected. No labels, names, expressions, fieldname, document names are collected.

- The entire dataset will be made available to the community for analysis when the collection is complete.

Thanks,

Rob

Re: Help with QV Function Survey

Anonymous — Tue, 21 Apr 2015 16:33:20 GMT

Where is Germany, Austria, France, Middle East?

My guess about functions: if()

Objects: straight table

Re: Help with QV Function Survey

rwunderlich — Tue, 21 Apr 2015 17:19:43 GMT

Michael,

Correct that if() is number#2. (Results are preliminary, still sifting outliers)

Function	Count	All Sites Rank	Highest Rank	Rank 1	Rank 2	Rank 3	Rank 4	Rank 5	Lowest Rank
sum	593240	1	1	80%	17%		2%		4
if	283875	2	1	13%	46%	35%	7%		4
max	131516	3	2		17%	13%	30%	28%	5
count	97679	4	1	4%	13%	37%	24%	22%	5
num	73201	5	1	2%	7%	15%	37%	39%	5

For Objects, Straight Table comes in at #4. Anyone else guess what the #3 object is?

Re: Help with QV Function Survey

Anonymous — Tue, 21 Apr 2015 17:26:50 GMT

My second choice for Object #3 is input box.

(Not a pie chart please!)

And, I'm surprised to see num() in top five.

Re: Help with QV Function Survey

rwunderlich — Tue, 21 Apr 2015 18:25:21 GMT

The #3 object is....Button.

Input Box is #1 for one submitter, but typically around #12 for the other sites.

There are some more surprises in the top ten Functions -- I'm still sifting the outliers but will publish some more preliminaries soon.

-Rob

Re: Help with QV Function Survey

rwunderlich — Tue, 21 Apr 2015 18:47:22 GMT

I'm getting "Cruscotto" as an Object Type from Italy. Can an Italian speaker tell me if this is a Native QV Object type and if so what is the English name? maxgro‌?

Re: Help with QV Function Survey

maxgro — Tue, 21 Apr 2015 19:08:00 GMT

cruscotto (image from a car) is a set of indicatori (or charts)

speedometer = tachimetro

traffic light = semaforo