Recent Discussions
-
Error When Sending an Excel Sheet with Qlik Application Automation
Hi there Qlik Community! I would like to send Excel reports with Qlik Application Automation. I am following this article that provides the JSON file ... Show MoreHi there Qlik Community!
I would like to send Excel reports with Qlik Application Automation. I am following this article that provides the JSON file to do this, but I am having a small problem with one of the Excel blocks. Additionally, I also wanted to create a quick template based on the designed by @MattGrayndler., which I later converted to base64. It has the sheet name and the table name.
I have a simple app, and this is the data I would like to send through E-Mail.
Lastly, with everything up and running (the app and the base64 template), I get this error in the CREATE EXCEL TABLE WITH HEADERS BLOCK. It is worth mentioning that the original JSON from the post works well. It is my Excel template the problem or something I am missing.
These are the settings of my block:
Does anyone know what could be the cause of this problem?
Thanks a lot!
-
Export entire sheet to png?
In qlik sense there are user options to export visualizations as png or pdf, and sheets as pdf. Is there any way via UI or API to export sheets as png... Show MoreIn qlik sense there are user options to export visualizations as png or pdf, and sheets as pdf. Is there any way via UI or API to export sheets as png as well? It would seem the capability should be there but I could not find the option anywhere.
-
Export to image API?
Hi !In Qlik Sense 2.1.1 you can rightclick on a chart and export to image (and also PDF). Which API can I use to be able to do this? I have searched i... Show MoreHi !
In Qlik Sense 2.1.1 you can rightclick on a chart and export to image (and also PDF). Which API can I use to be able to do this? I have searched in the Qlik Sense API-explorer in developer-hub but I can not find it. I have also tried to search then developer help but I have not found an API that I can use.
Best regards
Peter
-
Looking for info on Insight Advisor configuration methodology
Hello,I'm trying to configure Insight Advisor on an app and have found many of examples of how to do things like create a group, set visibility on a f... Show MoreHello,
I'm trying to configure Insight Advisor on an app and have found many of examples of how to do things like create a group, set visibility on a field, group/ungroup fields, enable/disable data value look up, etc. But what I cannot seem to find is much documentation on the reason to do (or not do) things. For example:
- When to hide a field and when to simply ungroup it instead.
- Should a dimension group only contain dimensions. Likewise, should a measure group only contain measures? Is it bad to mix fields of different classifications in the same group?
- Should I take each table in my data model and create one Dimension group, one Measure group and one Calendar group out of it? Or leave all of the table-related fields in a single group (which appears to be Qlik's default behavior)?
- What does it actually mean to hide a field? Who or what is it being hidden from? Why should I want to hide it?
- Since a field can only belong to one group, should "key" fields be ungrouped as opposed to putting them into only one table?
- You can't define business logic for an app unless it contains data. That's fine. But if I define business logic and then export the app without data, does the business logic remain intact?
- If I publish an app that has business logic over an instance that does not, does the business logic remain intact? What happens if the data model of the app being published over is slightly different than the data model of that app containing the business logic?
If anyone can point me to articles or videos that help answer the "why" of things, I'd be very grateful.
Regards,
Steven
-
Can I create Qlik Sense Dashboards for free
Hi there, I am working on a POC and I do not have the company log in credentials to Qlik Sense yet I have to prepare the dashboards using dummy data.... Show MoreHi there, I am working on a POC and I do not have the company log in credentials to Qlik Sense yet I have to prepare the dashboards using dummy data. How can I work on creating dashboards now ?
Can anyone please through some light on this topic.
Thanks and Regards
km
-
Error in exporting chart to Image or PDF using Qlik Sense API
Hello Everyone,i am facing a issue in November 2018,i am not able to export as PDF or IMAGE, but i am able to export the data to excel i need to imple... Show MoreHello Everyone,
i am facing a issue in November 2018,
i am not able to export as PDF or IMAGE, but i am able to export the data to excel i need to implement other export feature as well it will be great if you and others can help me on this issue.
Same error is coming for IMG alsoMy simple test code
var prefix = window.location.pathname.substr(0, window.location.pathname.toLowerCase().lastIndexOf("/extensions") + 1); var config = { host: window.location.hostname, prefix: prefix, port: window.location.port, isSecure: window.location.protocol === "https:" }; require.config({ baseUrl: (config.isSecure ? "https://" : "http://") + config.host + (config.port ? ":" + config.port : "") + config.prefix + "resources" }); require(["js/qlik"], function(qlik) { qlik.setOnError(function(error) { $('#popupText').append(error.message + "<br>"); $('#popup').fadeIn(1000); }); $("#closePopup").click(function() { $('#popup').hide(); }); //callbacks -- inserted here -- //open apps -- inserted here -- var app = qlik.openApp('APP-ID', config); //get objects -- inserted here -- // test app.getObject('QV01', 'OBJID').then(function(visual) { //console.log(visual); $("#exportChart").show().click(function() { //Working Good /* visual.exportData().then(function(result) { console.log('Data download link: ', result); }); */ //Not Working IMG /* var Imgsettings = { imageType: 'png', height: 200, width: 300 }; visual.exportImg(Imgsettings).then(function(result) { console.log('Image download link: ', result); }); */ //Not Working PDF var Pdfsettings = { documentSize: "A4", aspectRatio: 2, orientation: "landscape" }; visual.exportPdf(Pdfsettings).then(function(result) { console.log('Pdf download link: ', result); }); console.log("Exporting"); }); }); //create cubes and lists -- inserted here -- });
Can some one help me on this & please if i am wrong please explain me what was wrong.
Regards,
Ajay Kakkar
-
.NET SDK C# Image Export
Hi,So the people using JS got the Image export available with their API.Is there anyone that found a way to do this within C#? Apparently the API's fo... Show MoreHi,
So the people using JS got the Image export available with their API.
Is there anyone that found a way to do this within C#?
Apparently the API's for this are not public, but why??
I have got it to work with opening a browser and navigating through it to export the image and get it from the server. But this is not really reliable to use.
If the API's are not going to be public, is there a way to for example put a bit of JS within the application and handle this image export for the C# bit? If so does it need any install of node.js for example? I have not worked with JS and the Qlik API's.
If someone would be able to provide sample code for this last bit, that would be really awesome.
-
Access Denied Error (5) while trying to create new sheet group.
Hello,We recently upgraded to Qlik Sense on Windows November 2024 Patch 7 and I was excited to try the custom sheet groups feature as we have multiple... Show MoreHello,
We recently upgraded to Qlik Sense on Windows November 2024 Patch 7 and I was excited to try the custom sheet groups feature as we have multiple clients who have asked for this.
What I'm seeing, however, is that whenever I try to create a new group in a published app using Add To Group > +New Group, I get an Access Denied Error: 5 message.
The particulars are:
- I'm using a test app that I created containing data and one base sheet. (though I see this same behavior on all of our apps)
- The test app does not have section access.
- I create a new unpublished custom sheet (My new sheet) and try to add that to the new group as described above and get the Access Denied Error message.
- I am able to create/publish/delete apps. I am able to create/approve/publish/delete custom/community sheets. I can also create stories and bookmarks. In short, I have full Hub and QMC access.
And yet neither I, nor anyone else I work with, can add a sheet to a new group in a published app. Do I need to enable a security rule that's specific to creating sheet groups? If so, what would such a rule look like? I already have a rule to allow creation of app objects.
Thanks,Steve
-
wildcard search
hi, I am wondering why wildcard searching does not work in our dashboard for filtering. I saw some old posts of a similar nature that suggested that w... Show Morehi,
I am wondering why wildcard searching does not work in our dashboard for filtering. I saw some old posts of a similar nature that suggested that we need to change the code to allow it. Is that right? I just want to look for xxxx in the middle of a bunch of text and *xxxx* does not work. However if xxxx is the first 4 characters of a long thread I don't even need the * at all. Is there a way to search differently or do we need to change all the code on our whole large dashboard?
thanks
-
WHAT IS INTERVALMATCH AND HOW IT IS FUNCTION IN QLIKVIEW?
SALES:LOAD * INLINE [ORDER, PRODUCT, QTY, SALES PRICE001, A, 250, 12.56002, B, 40, 35.67003, C, 900, 56.8004, D, 579, 66.90005, E, 279, 765006, F, 467... Show MoreSALES:
LOAD * INLINE [ORDER, PRODUCT, QTY, SALES PRICE
001, A, 250, 12.56
002, B, 40, 35.67
003, C, 900, 56.8
004, D, 579, 66.90
005, E, 279, 765
006, F, 467, 446
007, G, 743, 67
008, H, 378, 68.9
009, I, 904, 12.4
];DISCOUNT:
LOAD * INLINE [
MINQTY, MAXQTY, DISCOUNT
4, 100, 27.9%
5, 200, 29.4%
76, 400, 12.7%
78, 455, 9.8%
86, 566, 41.9%
33, 342, 90.7%
];JOIN IntervalMatch(QTY)
LOAD MINQTY, MAXQTY, DISCOUNT;
In this why I'm using interval match ? can i use any other function to get the result ? what is the importance of interval match?