Can you send an example expression for funnel chart.

I can create only one stage

Thank You
Berk

Customer id / Customer Status
john active
emma passive
matt N/A

How can i add it to funnel. Which expression should i use ?

One point, in latest bootstrap bower project, the folder of less file goes down to bootstrap sub folder, so the import path should be : @import “./../bower_components/bootstrap/less/bootstrap.less”;

Your blog we got lot of information about the Qlikview and its very use full information
thank for sharing Qlikview extensions
can i get if you have Qlikview macro for exporting all chart from PDF
here i have company logo and one format i need to export all chart to PDF
which im not able to do it, if you can help me already developed code for exporting chart to PDF
for its great help

Thanks In Advance
Niranjan

about the use of bootstrap in sense, if i have more than one extension that use the bootstrap css i want to insert only one css in the html head.

it is possible to include the css in the document?
or the only way is to append it to head in the extension?

Thanks,
Loris

But I have still Problems with external fonts. I want to use glyphicons on my apps. Everythink but glyphicons are working fine. Does anyone have any solutions ?

I am having a problem with the Calendar extension for QlikView (11.20 on Windows 2008), not QlikSense, so I am not in the right comments blog. My apologies for this, but the Calendar blog for QlikView was closed.

I hope that you still would like to help me out with this.
The 2 issues are:

Line: 3
Char: 22966
Error: Object doesn’t support this property or method
Code: 0
URL: http…d3.v3.min.js

and

Line: 1
Char: 1
Error: ‘d3’ is undefined
Code: 0
URL: http…calendar.js

Hope to hear from you.

Regards,

Dominique.

Your blogs are great by the way.

Never mind… I got it working. Just a novice Qlik programmer error. Forget I asked.

By the way this is a super extension! Great job. New to Qlik just found your blog today. Very useful and helpful. Really like all your articles.

Currently, I just use an iframe in my application and include the url. Please how can I go about this. I am able to get the user details in the application page. I have tried to use app.field.select, all to no avail.

Thanks.
Kunbi.

Hi,

no not possible right now, but just added it to the list of Todos 😉

Regards
Stefan

thank you very much!
If it’s possible why I can’t customize number format for a measure, like # ##0 mln?

Yes, a lot of plans, but just not enough time 😉

Regards
Stefan

Thanks for sharing these useful and cool solutions. Great work!
Any plan to convert and share some of your cool qv extensions into sense extensions.
Tx.

Thx – good to hear!

Hi Stephen,

I have – some time ago – decided to use Webstorm instead of Visual Studio, IMHO just works better for all Javascript related projects, especially when you are trying to leverage node.js, server-side Javascript development, etc.

Regards
Stefan

What is the IDE that you are using?

Regards,

Stephen

I haven’t started creating extensions for Qlik Sense yet but when I do this will come in handy.
Just wanted to make a general comment and say that your work is very appreciated and I like the open source attitude.
Wish I had time to contribute but maybe in the future :).

Yes.

Line 3
Carácter 16721
Error Object doesn’t support this property or method
Código 0
URL http://qlikview/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/D3BulletCharts/lib/js/d3.v3.min.js

Line 6
Carácter 5
‘d3’ is undefined
Código 0
URL http://qlikview/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/D3BulletCharts/lib/js/BulletCharts.js

Line 110
Carácter 17
‘d3’ is undefined
Código 0
URL http://qlikview/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/D3BulletCharts/script.js&xrfkey=gXnCNHcLr8eYUzGK

Can you help me to work with this extension?

Thanks in Advanced.

-JFlorian

Hi Stefen,

It’s very god extension.
but i have doubt here,
suppose i have created 3 links in qlikview using HTML Extension.

How to give navigation one sheet to another sheet in Extension…

is it possible or not….????/

Hope you understand..

Thanks in Advance

thanks for a great post.
if i wish my pivot table to be export and each row populated instead of showing the pivot as is in qlikview, is it possible to modify script?

for example if i right click and export a Qlikview object i get row based information but with the macro the dimesions do not populate on each row.

Best
Brad

Hi Pat,
I did not get that error resolved. I ended up ditching this solution and instead I’m using the command line EDX executable. I think I got that from the Qlik Community website. The upside is that the command line EDX version works well. The downside is that it’s not “on demand” like this solution has potential for. Instead, I use the Windows Task Scheduler to schedule the EDX task every 15 minutes.
This solution still has potential, I just don’t have the time to mess with it.
-ken-

Hi Ken,

I am getting the same error (“Error posting the data to the webservice: Error Status: 0 Error Status: error”). Did you find a solution for this?

Much appreciated,

Pat

This is a great extension!!!!!! Is it possible to toggle the display to show weeks and months too??

Many thanks,

T Maher

I need some help..
i am also using same kind of extension (HTML Extension)

I have created 4 tabs in Extension..
if i am click any button i want to go other sheet in qlikview..
is it possible…???

if i am click button1 ====> Sheet1
button2 ===> Sheet2

same like 3 and 4 button also..

Hope you undersatnd..

Thanks in Advance……

Hello Stefan,

i am using html extension, i have 5 tabs in that,
like this,
XHTML
C++
Mootools
HTML5
CSS

if i am click any tab, i want to show particular sheet.
suppose XHTML tab, i want to go that sheet.

How to give active sheet ID….

Thanks in advance…

I am just a little confused as to how to handle the index.html part of the code when using as an extension. I believe I cant simply reference the index file, can I? I want to use the java script as it is in the source code or with minimal changes, but the code references all the elements created in the index.html file but i cant seem to figure out how to define the definition.xml file for this chart. Has anyone worked on this chart?

Any help would be greatly appreciated 🙂

Regards
Khan

I’m using the bullet chart extension with great pleasure. However, I’ld like to change the color of the numbers on the axis. Can you please tell me how this can be achieved?

thanks!
Nasir

i have server and workbench license. Interestingly i got this thing working with “http://community.qlik.com/message/306293” this setup. But not sure how i can integrate multiple objects in the same page. all he showed is a localhost path with single object.

any help will be greatly appreciated.

Qv.InitWorkBench({
View: ‘Sales Compass’,
Host: ‘QVS@Local’
});

I’m using Version 11.20.12354 SR6 64bit of Qlikview Dekstop.

On the web client, when select a few fields, it only shows the latest selected after 3 selection. I would like to know if there is a newer version of this extension.

Thanks.

I’m using Version 11.20.12354 SR6 64bit of Qlikview Dekstop.

On the web client, when select a few fields, it only shows the latest selected after 3 selection.

Thanks.

Anyone having more luck with this?

Thanks,
Lorna

Hi Fede,
I found this patch at the download site, and after recompiling with it I was able to get the reload to work via the button click in my Desktop version!
http://qvextcalledxfromajax.codeplex.com/SourceControl/list/patches

However, once I put the document on the Access point the button is not visible at all. The journey continues.

Lorna

Hello Stefan,
Thanks a lot for sharing ‘ Installing/Deploying QlikView Extensions’.
I am new to QlikView, Please I need your guidance on getting ‘Map’ – Extention (Google map) working on QlikView-AccessPoint.

The map (Google map with pins and clusters etc) is working fine on my desktop ( QlikView Desktop on Server )
But when I open report in Access Point the map object is not showing.
When I select AJAX -(Full Browser) the object does NOT show at all,Google map & pins does not load at all. also there are no error msg.
when you select IE Plugin the object it comes up as Bar chart.(I know Map objects dont work in IE plugin)

Server Info:
QlikView Version -11.0.11 SR2 – 64 bit
windows 2008 R2 Enterprise(64 bit)
IE-9

1)Extensions are copied on QlikView Srver at – C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objects\
2)Full Browser Version where AJAX is enabled
3)can access to maps.google.com on IE on server
4)The QlikView Server has access to internet, Also Qlikview Service account on server has access to internet.
5)System -> QlikView Servers -> Your QVS(s) -> Security -> Make sure “Allow Extensions” IS checked on QMS

AM I missing any configuration – server setting etc.
Is any QlikView Server settings I am missing?? Please suggest if any specific network or internet access or user access is required.

Your guidance & help will be very much appreciated.

Thanks

I am trying to use the extension in an environment without Publisher, and I can launch the EDX task from another executable utility that I found, so I think that confirms that the webservice etc. is set up properly. However the extension within my qvw throws the ‘No Distribution Service found’ error.

Thanks,
Lorna

Does this extension work on QV Personal Edition?

Thanks,

Julio.

Hi Fede,
I’m still working on this and will let you know what I find but so far I believe that we can do it without Publisher but the document will only be able to loaded via EDX OR on a reload schedule, not both. Not ideal for my purposes as I would like a daily reload that my user could then supplement by refreshing on demand but we’ll see.

Lorna

HI Lorna,

I haven’t received a direct answer to this, but I have the impression that EDX tasks are set under the Publisher component.

Fede.

I’m new with QlikView and I’m trying to set up your extension with no success.
I installed the extension, but no data was reloaded. I tried to reload an excel file, but nothing was reloaded.
I enabled the extension at Doc Properties > Extensions. Is there something else to do?

Thanks,

Julio

Hi Fede,
Did you get an answer to your question as this is exactly where I’m at. We have Enterprise, but not Publisher and I have a real need to add this functionality.

Thanks,
Lorna

Thank you for the updated Web Page Viewer. For most parts it works like a charm and helps us develop certain dashboards a lot faster. Have you ever stumbled on a problem where WebView (in QVDesktop) gives the error “your browser does not support xmldocument objects” when the URL is pointing to the QlikView server in the intranet (but not when the URL is pointing to a public url.

BR,
-Christian

Same problem for me, getting the javascript errors with the version with new color schemes. what could the issue be

I’m getting javascript errors on the latest version of Qlikview – it worked OK on QV 11.2 SR2, but wont work on QV11.2 SR6 – is there an issue?

Thanks

Dominic

Error Posting the data to web service
Error Status: 0
Error Status: error

How to configure the web service url in the extension
Do I need to place the web service code in the IIS server?

This article help me a lot, but what I need is to somehow calculate number of rows in each table object and set next qlikview object two or three rows below previous one. Can you help me to manage this?

Dim aryExport(4,3)

aryExport(0,0) = “objSalesPerRegion”
aryExport(0,1) = “Sales Overview”
aryExport(0,2) = usedrows
aryExport(0,3) = “image”

aryExport(1,0) = “objTopCustomers”
aryExport(1,1) = “Sales Overview”
aryExport(1,2) = usedrows + 2
aryExport(1,3) = “image”

aryExport(2,0) = “objSalesPerYearAndRegion”
aryExport(2,1) = “Sales Overview”
aryExport(2,2) = usedrows
aryExport(2,3) = “data”

aryExport(3,0) = “objTopCustomers”
aryExport(3,1) = “Top Customers”
aryExport(3,2) = usedrows + 2
aryExport(3,3) = “image”

aryExport(4,0) = “objTopCustomers”
aryExport(4,1) = “Top Customers”
aryExport(4,2) = “A14”
aryExport(4,3) = “data”

Dim objExcelWorkbook ‘as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

Error Status: 500
Error Status: Internal Service Error

Thanks a lot. We have a team that can develop the webservices and your extension will solve too many issues that we have.

I am traveling getting this extension to work.

I am using QlikView Desktop Client 11.20.12235.0 SR5 64-bit

I downloaded D3BulletCharts_v1.0.1.qar and successfully installed it without errors.

I switch to WebView and can Add New Sheet Object and can drag the D3 Bullet Charts object onto the tab.

BUT:
I can’t get the Properties to keep anything in Range1, Range2, etc. As soon as I close the Properties, they are erased. And the chart displays nothing. I can change the chart Caption, but that seems to be about it.

Any ideas?

Hi, i have the same problem someone have a soluttion ??
Hola, tengo el mismo problema, alguien tiene la solución?

Thanks
Gracias!

Theoretically yes, but would not be supported by many browsers and you would run into security-troubles, so i fact: NO …

Regards
Stefan

The Set Analysis Wizard is a private project (as everything on this page), therefore there are no plans to integrate it into the product!

Regards
Stefan

This can happen; if the owner of the website is defining that the website cannot be displayed within an iframe, then you’ll get this message. This e.g. also happens if you are trying to display Google’s startpage in an iframe …

Regards
Stefan

=’http://server/FG/SandOP/Reports/SP_Monthly_Purchase_Report.rdl?Web=1′

Starting to work with the QlikView Management Services API (QMS API), Some Useful Resources (QlikTip #51)…

with IE9 i get this error message: “Error Status: Error: Could not complete the operation due to error c00ce56e”
How can I solve the issue? I’ve got some users that can’t upgrade IE

Thanks
S

Does it mean that this extension can´t be used without QlikView Publisher.

Thanks for confirming.

Fede.

My family every time sayy that I am wsting my
time here at net, buut I know I am getting familiarity daily by reading hes good content.

My site … envoi sms

I would like to know how to install/set up the web service from your example.

Thanks in advance,
Regards.

Thanks again for sharing this tool!!

Regards.

Iwould like to know whether you do or intent to share the source code for this application ?

Thanks in advance,
Best Regards,
vand

I would like to know whether you do or intent to share the source code for this application ?

Thanks in advance,
Best Regards,
vand

I am placing my HTML file in qlikview rootfolder(i.e Qlikview/web). My HTML is having Chart Objects. I am trying to access the HTML from the browser, then I can able to view the charts objects in the browser. But I am trying to access from the iPad, I can’t able to access the chart Objects.

For iPad, In XCode I created the project. And from UIWebview, I am trying to access the HTML file which is in server.
In HTML file, I placed two anchor tags and two Chart objects(By using the ).
HereI can able to view the anchor tags in iPad simulator but I can’t able to view the Chart Objects.

Please Help me on this.

Thanks & Regards,
Murali Krishna.

Hi Shawn,

yes, it seems to be related to 11.2 SR5, I have also received some other emails (with other extensions) that they do not work in 11.2 SR5 …
So I’ll have to investigate …

Regards
Stefan

I have also downloaded your latest version and when have one feild in the selection box and I click the clear icon in the “Better Current Selection-box” nothing seems to happen. Neither in the “Better Current Selection-box” nor in the “standard” current selection box.

Clicking on the clear icon in the “standard” current selection box works and it also removes the selection made from the “better current selection-box”.

I have also experienced that if I select three dimensions and select to remove one of them (for example the 1st one), then the 2nd dimension is removed instead.

Could this be related to QlikView 11.2 SR5? ( we recently upgraded)

Please respond as this is a great tool and I want to put into production asap.

Do you have some idea to solve the problem below,

http://community.qlik.com/thread/84641

if i call an oracle procedure which has variables of REF CURSOR, how to write the script,

BR,
Thanks,

Jam

Your AutoRefresh extension fits my needs perfectly and it’s running like a dream! Thanks for sharing it.

Cheers,
Michiel

Dear Stefan,

Thanks for providing Macro.

1. while auto reloading the application macro need to run and Excels will be save in particular path. this actions are not happen in above macro.

so if you have the save the Excels macro, share me.

Thanks&Regards,
vinodh c

I am using this Extension and I have the problem that I can not select any text in the “Direct Template”-textarea to copy the code. Is this a normal behaviour or is there something wrong within the configuration of my environment?

Any hint is appreciated.

Thanks,

Dietmar

I have taken your extension and tried to customize for clearing the selections.
Is there any way we can clear multiple selections at a time?
Can you help me and let me know what need to changed in the below code to clear multiple row numbers.

G.position = “0:” + rowNo + “:Body”;
Qva.GetBinder(“”).Set(m + “.CD”, G);
Qva.GetBinder(“”).Send(“”);

I’ve set up my document to switch to a new tab automatically based on the selections, this way each tab can maintain the specifics for that level of the portal. I’m having an issue though where it works to drill down (from company to segment, from segment to business unit.. etc) however when trying to return up a level qlikview seems to lock the object to the previous selection state.

I’ve tried changing the options to prevent reloading, on and off.. I’ve made action scripts that store the selections to variables, wipe out the selections, and then reselect the field based on variable to force the object to load a new address… nothing. This drill-through action is critical to the portal environment I’m developing so any ideas would be extremely appreciated.

Thanks,
Damien

Error posting the data to the
Error Status

what I am missing?, your ext work fine no issue but on submit it is giving this error

and error does not say any thing it is just ur javascript alert

Hi Stefan,

there is not such possibility in this extension but could probably quite easily achieve … I will have to have a look into the code and hopefully send you an update 😉

Regards
Stefan

I am in consulting services, but new to QlikView. Trying to learn as fast as I can – coming from years in OBIEE.
This looks like a great tool. Thanks. I have the feeling that “one who masters set analysis, masters QlikView” 🙂
I am looking to put in the time to master this, and suggestions would be greatly appreciated.
Are there any examples that can generate E() ?
So, for example: “Show me customers that have made no purchases (Sales is the measure) in the last 3 months? ” I.E. not necessarily Sales <=0 ; just customers that have not purchased any products in the last 3 months.

Thanks,
Dave