Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a spreadsheet to load into Qlik in the following format:
Order ID | Org1 | OrgType1 | Amount1 | Org2 | OrgType2 | Amount2 | Org3 | OrgType3 | Amount3 |
10001 | AAA | Internal | 1000 | BBB | Internal | 300 | CCC | External | 600 |
10002 | DDD | Internal | 1500 | AAA | Internal | 200 | EEE | External | 900 |
10003 | EEE | External | 800 | FFF | Internal | 700 | AAA | Internal | 1200 |
...and so on.
But what I really want to work with in Qlik is a table like this:
Order ID | Org | OrgType | Amount |
10001 | AAA | Internal | 1000 |
10001 | BBB | Internal | 300 |
10001 | CCC | External | 600 |
10002 | DDD | Internal | 1500 |
10002 | AAA | Internal | 200 |
10002 | EEE | External | 900 |
10003 | EEE | External | 800 |
10003 | FFF | Internal | 700 |
10003 | AAA | Internal | 1200 |
Can anyone tell me how to get my data into that format?
Thanks in advance,
Dan
Hello,
Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error message "connection denied nametenant.eu.qlikcloud.it"
Is there any setting to set up?
In practice: I made the sheet public, I took the embedded, I pasted it on my web page www.dominio.it/qlik.html and I pop up the notice described.
When trying to create a filter in the 'Filter' section of Reporting, I have trying to filter based on a dimensional value.
When I select the dimension, it just appears as my if statement in the dimension. I chose search, evaluate, etc. to find the value that I want but it keeps telling me it is invalid.
How do I filter based on a dimension
I have a SQL Server database that has merge replication configured with another SQL Server, I need to replicate some tables using Qlik Replicate, we know that CDC cannot be activated, I would like to know what the restrictions are in relation to transactional replication, if This impacts merge replication that already exists, if Qlik uses other logs than the one already being used by MERGE.
Hi,
I'd like to replace in my script some nested previous used to find the last value for a field (in this case, the supply source) in a table that have values similar to:
Tab:
Load *,
If(len(trim(Source2))= 0 or Source2='NULL' or Source2='-', Null(), Source2 ) as Source
INLINE [Trip Stop Type Source2 Pickup Delivered
a1 1 1 a 20 -
a1 2 2 - - 11
a1 3 2 - - 6
a1 4 2 - - 2
a1 5 3 b 18 -
a1 6 2 - - 16
a1 7 4 - - 3
](delimiter is ' ');
This would be a tipical trip, in which there are 4 types of Stops: 1 for initial product pickup, 2 for delivery to customers, 3 for others product pickup (e.g. in a provider) and 4 for product returned to plant.
I need to identify the source for each stop (that would be the previous source untill the truck stop in a provider, changing the source, type 3) and I solve this situation by using nested "previous" function as follow. Could you help me to simplify this scrip? (maybe with peek function or using other one).
My initial solution was:
RESIDENT Tab;
DROP TABLE Tab;
I recently started seeing a problem in bar charts and line charts: the value labels are not visually all there. Two examples:
If I resize the chart or the web browser, I can eventually get it to look good. It doesn't happen with tables, and I haven't noticed it in other visualizations. It happens on other computers and in different web browsers. It doesn't happen outside of Qlik. We're on Sense Enterprise February 2023, client-managed.
Are others having this problem?
I have a dimension that I created called Proposed Bucket.
Here is my if statement:
I want to create a measure that adds up certain elements of this proposed bucket.
In the wake of the recent surge in the adoption and advancement of Large Language Models (LLMs), I've found myself contemplating the profound implications for the field of analytics and the evolving role of data and business analysts.
With each stride made in natural language processing technology, my fascination with its transformative potential only deepened. However, as I delved into the current applications of LLMs and Generative AI, I couldn't shake the sense that something vital was missing.
Despite the undeniable capabilities exhibited by these models, their relevance to real-world business scenarios often seemed nebulous. The disconnect between the touted examples and the practical needs of businesses left many questioning the applicability of these technologies.
It was amidst this backdrop of uncertainty that the concept of Language-Centric Analytics began to crystallize in my mind, after much reflection, discourse, and experimentation. This paradigm shift places language at the heart of the analytical process, recognizing its innate familiarity and accessibility as a means of interaction. By reframing analytics around language, we pave the way for a more intuitive and inclusive approach to data exploration and interpretation. The journey towards Language-Centric Analytics holds the promise of reshaping not only how we analyze data but also how we perceive and harness its potential to drive meaningful insights and informed decisions.
About that topic, I just published a short article in the Data Voyagers blog. This text serves as an introduction to this concept. I hope you all enjoy it.
The Rise of Language-Centric Analytics (datavoyagers.net)
I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in excel, objects or tables are not rendering properly ,Do you have any solution?
1. I am using container having 3 different charts ,In NPrinting report first and last tab are rendering, but middle one NOT rendering , this occurs in other containers as well in my Qliksense application.?
2. Cannot apply alternative dimensions in Barchart,in NPrinting -only return/render Barchart with default dimension. ?
3. Straight Table with Chart Exploration: NPrinting only return the 3 default columns, which is available in chart Exploration in straight Table?
4. Straight Table Extension with chart exploration is an extension? Can you confirm same extn supported by NPrinting May 2023 SR2 Version.?
My core Qliksense application version is May 2023 Patch 6 .
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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!