Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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?
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.
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
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.
Hi! I'm currently using requirejs to load qlik on my mashup:
```index.html
\<script
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 |
お疲れ様です。
GeturrentSelectionsやGetFieldSelections等でステートを指定することが可能かと思います。
指定してない状態ではその式が記述されているオブジェクトのステートが選択されているかと思います。
そこで、例えば「ステート1」に指定されたシートで標準の状態である「<デフォルトの状態>」で選択されているフィルターの情報を上記関数等で抽出したい場合、関数内で指定する必要のあるステート名はどうなりますか?
<デフォルトの状態>ではヒットがしなかったため回答を持っている方いらっしゃいましたらご回答の方お願いいたします。
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
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
Workshops. Certifications. And Disney's Animal Kingdom® Theme Park. Only at Qlik Connect. May 13 - 15.
Optimize your data strategy with Iceberg lakehouse insights, cost-saving tips, and a preview of Qlik Talend Cloud’s no-code integration.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
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.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!