Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am going to connect to an API via an automation since there is a connector avialable but then I want to send the data I retreive into a DataFile in a Space where Qlik Sense can pick it up and use it in a dashboard. The blocks around dataFiles are very confusing and none of them seem to have the content field where I can put the data itself.
Any clarifications or advice on the Datafile blocks are welcome. I have done some scripting on Qlik-Cli to upload data files from a local machine but this is all cloud and the blocks don't seem to fit with the way the qlik-Cli worked.
Thanks
I am wondering if there is any plan for an equivalent of elastic search components for OpenSearch.
Also, I am very new to talend, so if there are any tips for creating custom connections to a database, I am all ears!
1. DOUBLE CLICK
I always promote Qlik Sense as one of the best-in-class data analytic tool that designed by software engineers that always put end user in mind - ease of use.
There are not many tools allow end users or developers to create a chart within a minute by just 'double clicking)' (of course, provided, all master item dimension and measure have been set accordingly.).
To create a chart, all users need to know is 3 things: Dimension, Measure, Chart Type. Then, next thing to do is to stay focus on the property panel in Right. the rest is just double clicking.
Not anymore.
Now, whenever we double click a field or master item (where an active object is in chart), QS NO LONGER will add the selected item into the active chart, but to create another NEW object!
drag and drop is just not the same. plus, now time could be spent in deleting object that we created by accident.
The feature that referring in this post is, when in edit mode of a sheet,
1. Double clik any chart
2. At field or master item, double click one Dimension/measure - that dimension/meausre will actually going to be added into the selected chart, NOT creating ANOTHER new filter or table or new object. or if the chart already has dimension or measure, it will ask if we need to replace or color by etc.
2. LAZY SEARCH RESULT DISPLAY
This is about the search result display page from hub, when it displays the results, it just shows the minimum possible columns info with matched criteria.
The current search result really show not much value but a liability to some or most who might constantly do the search then forgot abt need to go to catalogue if we have too many app with same name in many spaces. Below is your search display from catalogue section.
The catalogue page is good, but still not good enough:
1. if possible, let us choose the column to display, if not, pls at least have:
a. app size
b. user view
c. owner
d. enable column sorting by clicking on column
Apply your search result design page across the entire app should be consistency.
Hi,
I'm working on an app that will allow users to be able to export an entire sheet or an individual chart/table as printable pdf files. The feature used to work properly before, but now it seems bugged. Each time I try to use this feature, it gives me such a message 'An error occurred during export. Please try again'. And of course, when I try again it produces the same message anyway. It has been this way since yesterday, and the issue persisted right now.
Does anyone know what happens to my Qliksense? It seems to be affecting other apps as well, so I doubt it has to do with a change I made for the app I am working on. Moreover, I cannot seem to find the location of the log files for Qlik desktop, this does not help with the situation either, please let me know where the log files are located for this kind of export sheet errors if there are more details I can look up, thanks.
Hello there,
I have two tables, which have no relationship, but I need to add info from one table into the other as a dimension.
These are my input tables:
and
And this is the desired output table:
The input tables come from different "owners" and have more records, I just need to know how to create the [Desired Output]: at the load script.
If it were only one project, I would have added this:
'NBU' as [Project Acronym]
when loading [Systems Data]:
But since this value [Acronym] can be variable and it comes from a file, I need to read it from [Project Data]: and "append" it to [Systems Data]: somehow. However, since there is no field that can provide a link between the two input tables, no JOIN works.
Any ideas will be appreciated!
Thank you!
I keep seeing this error in the Qlik License Monitor Dashboard.
There are apparently no issues with the Qlik environment, i.e. Tasks are run, Apps are refreshed etc. but the logfile errors persist.
The only pattern seems to be the error occurs around the same time within each hour which suggests a scheduled task may be at fault but I see/get no errors in the task list. (The Service Account has a Professional License allocated to it)
Any ideas?
Hi Qlik Community,
We have a requirement where we need to design an app in such a way that Grand Total and custom sub total not changed by app filters. For example, I have below hierarchy,
Region----->State----->Store
By Default this is how app would look like
Now when someone select a state from State filter, it would change the data in table including subtotal and grand total, like below
But we have requirement that subtotal for level above the selected filter shouldn't change and show the data as below
I am looking for ideas to implement this solution. Also we have more then 20+ KPIs so any solution which is easy to implement, flexible and extendable would be great for maintenance purpose.
Thank you
Hello everyone.
I would like to ask for your help with a very important topic: I want to create a cumulative total in a table. The problem I have is that when I perform the cumulative calculation, the RowNo()
function distorts a column that should be sorted in descending order.
Now I am going to show you a table that is working.
You can see that I have a table of quantity sorted in descending order, your participation and the cumulative participation all in percentages.
Quantity: Sum({<%Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
Cumulative %Participation:
Sum({<%Flag_Flag_Invoice={1}>} QUANTITY * If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
/
Sum(TOTAL{<%Flag_Invoice={1}>} QUANTITY * If(If(IsNull(MENGE.STPO), 1, MENGE.STPO) * Sign)
%Accum:
RangeSum(Above($(v%_Accumulated_Quantity),0,RowNo(TOTAL)))
Being the variable $(v%_Accumulated_Cant) equal to %Accum Share I did it this way just to make it look neater.
BUT!
When I add an extra dimension, my quantity gets messed up and doesn't look right.
NOTES:
In the sort tab I set the first dimension to sort by expression and the rest I unsorted the sorts and it didn't work either.
What can you do!
Please!!!
Regards
Hello, I would like to ask for your help.
I am trying to bring data from a GAQL query, in order to list all ad accounts linked to my Google ads account. However, it is noted that to perform a GAQL query using the Google Ads API, it is necessary to inform an ad account id (example: customers/1234567890), which limits the search to a single account. In that case, how could this general listing be made?
*(I note that in the api interface itself, such functionality is presented in the accounts part, but limiting the choice to only 1 account as well).
The GAQL search query from that part would be this one correct, but how would this listing be done?
SELECT
customer_client.client_customer,
customer_client.id,
customer_client.level,
customer_client.manager,
customer_client.status,
customer_client.time_zone,
customer_client.descriptive_name
FROM customer_client
Thank you for your attention!
Hi all,
I’m currently migrating a mashup from Qlik On-Premise to Qlik Cloud.
My mashup uses Enigma.js and Nebula.js for visualizations, but I’m running into issues while trying to obtain the CSRF token. I’ve tried two different approaches:
Here’s the scenario:
userId
as parameter, and retrieves a web token via OAuth impersonation.In this scenario:
I suspect the issue might be that the /api/v1/csrf-token
endpoint isn’t designed to issue a CSRF token when a web token is used as an authorization bearer token. The documentation includes an example with an API key, but that solution isn’t feasible in my case because multiple users need access to the mashup.
Can anyone offer some guidance on this?
Thanks for the support!
Cristian
We are thrilled to announce that the new Qlik Learning will launch on February 17, 2025.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
From product innovation, to technical tips and tricks, to real world success stories, Qlik Connect offers learning opportunities for all levels.
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 enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
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!