Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024
A EXPRESSÃO QUE ESTOU USANDO É:
( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)
ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
Hello, I am trying to setup a Generic LDAP UDC to our Google Workspace domain using the Google LDAP server. The setup process seems to fail because of a timeout but I can connect and browse through the LDAP server using Softerra LDAP Administrator. The certificate from Google is installed in my user's certificate store, the service user's certificate store, and in the local machine certificate store. The firewall is disabled. Running on Windows Server 2022.
From the Repository\Trace\UserManagement_Repository log:
"Fetching directoryentry LDAP://ldap.google.com:636 failed: This operation returned because the timeout period expired.
Setting up UDC of type Repository.UserDirectoryConnectors.LDAP.GenericLDAP unsuccessful Setting up connection to LDAP root node failed. Check log file."
From the Proxy\Trace\System_Proxy log:
"Failed to authenticate stream as Server An unknown error occurred while processing the certificate↵↓A call to SSPI failed, see inner exception. NO-STACKTRACE
Above happened because: An unknown error occurred while processing the certificate NO-STACKTRACE
Unanticipated System.Security.Authentication.AuthenticationException occurred accepting client, disposing connection attempt"
Hi,
I have migrated a .nsq file from NP-v16 to the Qlik Nprinting 2021 and changes to reports.
Now i want to import only one specific Report from .nsq zip file to overwrite the recent changes.
When i clicked on Import NP 16 Report(as in below screenshot), it shows all the other report except the report I want to replace.
Any suggestions, please.
Hi all,
I started to develop an extension for graph visualization based on the Graph Dracula Library, using Raphael: http://www.graphdracula.net
This seems to be an interesting topic. First of all, what is the best data representation of graph data in a relational QlikView world? Second, there are a lot of limitations using those JavaScript libs. I've tried some before (D3.js etc.) but Dracula seems to have the simplest interface for my use case.
What is your opinion?
- Ralf
Qlik Compose for Data Warehouses
how to read pdf file which contain text, graph and tables also but i want only load table data into database, what should i do? which custom component used?
I have a table that I need to filter based on multiple columns. The scenario is that I need to look up a worker's name and filter the table if the worker's name shows up in ANY of the columns below:
Worker
Level 1 Manager
Level 2 Manager
Level 3 Manager
Level 4 Manager
I need to show the entire supervisory org based on the selected worker. Thank you for any assistance you can provide.
How to display the last transaction that has multiple rows. Example here is my data
transaction_id | transaction_date | account_name | items | amount |
9850840 | 5/10/2004 | Mikey | A | 10 |
9850840 | 5/10/2004 | Mikey | B | 15 |
9850840 | 5/10/2004 | Mikey | C | 20 |
4536281 | 5/11/2004 | Mikey | D | 10 |
4536281 | 5/11/2004 | Mikey | E | 15 |
4536281 | 5/11/2004 | Mikey | F | 20 |
7653428 | 5/12/2004 |
Mikey |
G | 10 |
7653428 | 5/12/2004 | Mikey | H | 15 |
7653428 | 5/12/2004 | Mikey | I | 20 |
7894566 | 5/11/2004 | James | A | 15 |
7894566 | 5/11/2004 | James | C | 20 |
7894566 | 5/12/2004 | James | D | 10 |
8664523 | 5/12/2004 | James | E | 20 |
8664523 | 5/12/2004 | James | E | 20 |
8664523 | 5/12/2004 | James | K | 30 |
I want to display in a chart table
account_name | items | amount |
Mikey | G | 10 |
Mikey | H | 15 |
Mikey | I | 20 |
James | E | 20 |
James | E | 20 |
James | K |
30 |
The Example I saw mostly sum up the amount, so it will only have 1 rec per account name, but i want to display the details.
master item last_transaction_id = FirstSortedValue(transaction_id,-transaction_date,account_name) will give me the last transaction_id per account name. How do I display all records associated with this transaction_id if I dont want to display the transaction_id. I can't get the set analysis syntax correctly, something like {<transaction_id = last_transaction_id>} account_name, {<transaction_id = last_transaction_id>} item, {<transaction_id = last_transaction_id>} Amount. i appreciate any help on this. Thanks.
Hello,
I have a dimension called ''Exercice période'' in French which mean Period exercice. I want to systematically select the previous month of the period, as an example, we're in May, I want to select April.
Any expression for that please?
Thank you so much
I am creating a simple mashup and it generates below config --
var config = {
host: window.location.hostname,
prefix: prefix,
port: window.location.port,
isSecure: window.location.protocol === "https:"
};
This is then used to make websocket calls , like https://<host>:<port>/<prefix>/app/engineData?reloadUri=....
I am exposing the dashboard through a different domain. I need to authenticate separately and pass a 'token' to this websocket call.
Like https://<host>:<port>/<prefix>/app/engineData?reloadUri=....&token=<TOKEN>
How to configure the config options to pass this token in every websocket call?
This question is for Qlik Sense enterprise edition.
Why don't these two example charts show the same colors (see example image)?
Top chart: I first created this one. Appearance settings is custom colors by dimension Dim2, and I have chosen a color scheme from my custom theme.
Bottom chart: I duplicated the first chart, and the only thing I changed is the appearance color setting. Here I have chosen colors by expression, and the colors that the expression defines are the same color codes as in the custom theme palette used in the top chart.
Why are the colors in the topmost chart "faded"?
The hex codes for the colors are exactly the same in the expression as in the custom theme definition. I don't understand why the colors are faded in the top chart.
Qlik Sense Enterprise on Windows February 2024 patch 3.
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.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
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!