Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 249,143 members
  • 7,068 online
  • 2,031,743 posts
  • 152,961 Solutions
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Qliksense reload button creation question

      1) I made a reload button through Widget editor by Googling.   2) I want to see it in the form of these buttons in the sheet, but I don't know how... Show More

    SH777_0-1676620874303.png

     

    1) I made a reload button through Widget editor by Googling.

    SH777_1-1676621028630.png

     

    2) I want to see it in the form of these buttons in the sheet, but I don't know how.

    SH777_2-1676621048384.png

    Or if there is any other way to make a reload button, I would really appreciate it if you could let me know.

    please reply if possible
    thank you.

    Show Less
  • forum

    Data Quality

    Dealing with differences in positive and negative quantity and price in Sales

    I'm working with a table that has these 4 conditions: Positive quantity & Positive Sale - regular Sale Negative quantity & Negative Sale - as it seems... Show More

    I'm working with a table that has these 4 conditions:

    Positive quantity & Positive Sale - regular Sale

    Negative quantity & Negative Sale - as it seems it's a Return

    Positive quantity & 0 in Sale - as it seems it's a gift/promo item

    Positive quantity & Negative Sale - can be an error or refund

    How can I deal with these different types of sale to calculate margin and margin%? Is it better to convert all the errors/refunds to negative quantities?

    Show Less
  • 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
  • forum

    Connectivity & Data Prep

    Identify source field value in FROM_FIELD load

    Hi all,   I want to use LOAD ... From_Field (...) to extract data from a field containing XML structured data. Let's say this is not an issue and I ma... Show More

    Hi all,

     

    I want to use

    LOAD ... From_Field (...)

    to extract data from a field containing XML structured data. Let's say this is not an issue and I managed to successfully code that (at least on some PoC data).

    I'm struggling to connect records in the result of this load with the record in the source table.

     

    As an example - let's say we have a table with Invoices, which contains Invoice Items stored in a single field as XML. LOAD ... From_Field generates the table with all of the Invoice Items, but unless there is a reference to Invoice ID included in XML, I'm not able to link Invoice Items to the specific Invoice.

     

    Also, if the structure of embedded XML is slightly more complex (and therefore I need to load the data using multiple LOAD statements), I have difficulties connecting these tables (autogenerated keys from XML loads reset to 0 with each record). I found out that FileName() function helps, but I'm not really sure if this is the right solution.

     

    Any ideas?

     

    Many thanks.

    Show Less
  • forum

    Integration, Extension & APIs

    Mashup in external server with RequireJs [load time]

    Hi! I'm currently using requirejs to load qlik on my mashup:```index.html\<script      src="../../resources/assets/external/requirejs/require.js"     ... Show More

    Hi! I'm currently using requirejs to load qlik on my mashup:

    ```index.html

    \<script

          src="../../resources/assets/external/requirejs/require.js"
          data-main="index.js"
        \>\</script\>
    ```
     
    ```index.js
    var config = {
        host: window.location.hostname,
        prefix: window.location.pathname.substr( 0, window.location.pathname.toLowerCase().lastIndexOf( "/extensions" ) + 1 ),
        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 ) {
        console.log(qlik);
    });
    ``` 
     
    The problem with this approach is that the requirejs provided by qlik import a lot of js modules which last about 12 seconds, which is quite a lot just load the mashup. Is there any other ways to be able to use the qlik API on the mashup?
     
    adecora_1-1744196232638.png

     


     

     
     
    Show Less
  • forum

    Visualization and Usability

    Trigger in past 5 rows

    Hello, I am trying to create the final column in my table below that will flag if the Amount < Expenses Trigger has been hit in 5 days prior to the da... Show More

    Hello, 

    I am trying to create the final column in my table below that will flag if the Amount < Expenses Trigger has been hit in 5 days prior to the date of that table row. 

    Struggling to make this work so any insights would be greatly appreciated 🙂

    Date Amount Expenses Amount < Expenses Trigger Trigger Hit in Past 5 Days
    18-Apr-25 11,039 10,528 FALSE N
    17-Apr-25 11,039 10,528 FALSE N
    16-Apr-25 11,020 10,528 FALSE N
    15-Apr-25 11,193 10,528 FALSE N
    14-Apr-25 11,164 10,528 FALSE N
    13-Apr-25 11,028 10,528 FALSE Y
    12-Apr-25 11,028 10,528 FALSE Y
    11-Apr-25 11,028 10,528 FALSE Y
    10-Apr-25 10,870 10,528 FALSE Y
    09-Apr-25 11,004 10,528 FALSE Y
    08-Apr-25 10,335 10,528 TRUE Y
    07-Apr-25 10,375 10,528 TRUE Y
    06-Apr-25 10,563 10,528 FALSE N
    05-Apr-25 10,563 10,528 FALSE N
    04-Apr-25 10,563 10,528 FALSE N
    03-Apr-25 10,563 10,528 FALSE N
    02-Apr-25 10,563 10,528 FALSE N
    01-Apr-25 10,563 10,528 FALSE N
    Show Less
  • forum

    Visualization and Usability

    Layout Container Question

    Hi Everyone, I'm on Qlik sense on prem version November 2024.Can I put a tab container or a container inside a layout container? 
  • forum

    Japan

    ステート<デフォルトの状態>について

    お疲れ様です。GeturrentSelectionsやGetFieldSelections等でステートを指定することが可能かと思います。指定してない状態ではその式が記述されているオブジェクトのステートが選択されているかと思います。そこで、例えば「ステート1」に指定されたシートで標準の状態である「<デ... Show More

    お疲れ様です。

    GeturrentSelectionsやGetFieldSelections等でステートを指定することが可能かと思います。

    指定してない状態ではその式が記述されているオブジェクトのステートが選択されているかと思います。

    そこで、例えば「ステート1」に指定されたシートで標準の状態である「<デフォルトの状態>」で選択されているフィルターの情報を上記関数等で抽出したい場合、関数内で指定する必要のあるステート名はどうなりますか?

    <デフォルトの状態>ではヒットがしなかったため回答を持っている方いらっしゃいましたらご回答の方お願いいたします。

    Show Less
  • forum

    App Development

    Help with possible function

    Hello,Can anyone please help me with below?I have a data set User      Year    FlagAAA        2025     -AAA       2024     YAAA        2023    YOn the... Show More

    Hello,

    Can anyone please help me with below?

    I have a data set 

    User      Year    Flag

    AAA        2025     -

    AAA       2024     Y

    AAA        2023    Y

    On the SHEET i have a condition to show only if Flag='Y' .

    But that SHEET should also appear to user AAA when Year 2025 is selected where Flag is null (because he had Flag = 'Y' in prior years - sheet should show regardless of selected Year if he ever had Flag Y)

    Can anyone please help with the condition to use on the sheet for above scenario?

    Thanks in Advance

    Show Less
  • forum

    App Development

    Set analysis on concatenated fact data

    Hi,I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to c... Show More

    Hi,

    I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to calculate with Set analysis the number of issues per Category, but it should calculate as follows:

    for Category A : 2 (Issue X and Y) + 1 (Issue linked through Order M)

    I believe it is possible with P function in Set analysis, but I cannot succeed with it.. appreciate any help

    justalkak_0-1745333593849.png

     

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

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

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