Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 247,657 members
  • 2,806 online
  • 2,030,443 posts
  • 152,848 Solutions
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    Application Automation

    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 More

    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 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.

    rolmontero_0-1731415721045.png

    I have a simple app, and this is the data I would like to send through E-Mail.

    rolmontero_1-1731415808953.png

    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.

    rolmontero_4-1731416473599.png

    These are the settings of my block:

    rolmontero_5-1731416530226.png

     

     

    Does anyone know what could be the cause of this problem?

     

    Thanks a lot!

     

     

     

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    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 More

    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 as well? It would seem the capability should be there but I could not find the option anywhere. 

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Integration, Extension & APIs

    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 More

    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 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

    qs01.png

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Insight Advisor

    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 More

    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 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    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. How can I work on creating dashboards now ? 

    Can anyone please through some light on this topic. 

    Thanks and Regards

    km

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Integration, Extension & APIs

    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 More

    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 implement other export feature as well it will be great if you and others can help me on this issue.

    exportPdf_exportImg_issue.PNG






    Same error is coming for IMG also

    My 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Integration, Extension & APIs

    .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 More

    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 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.

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Management & Governance

    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 More

    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 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    Visualization and Usability

    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 More

    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 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

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
  • forum

    App Development

    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 More

    SALES:
    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?

    Show Less
    Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Weekly Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!