Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
When a pie chart or a donut chart is natevely created in the PixelPerfect template, there is a bug displaying the last label of the percentage.
In fact if the last percentage and first percentage values are between 1% and 3% than their label get swapped clockwise after the first label. Wrongly displaying the labels.
The Resolve Overlapping Mode property behavior does not move the label to the right side. See attached images.
It happens on all NPrinting versions.
How can this be fixed?
Kind regards
Hatus Peters
Hi all,
I have 2 fileds: AccountID and Scope. Some Account does not have a Scope (null in scope) and I would like to find them. I can work only in Front End, so no load script can be used.
E.g.:
Account | Scope |
1234 | Scope 1 |
2345 | - |
345 | Scope 2 |
I managed to create a KPI that show how many Account with null scope I have, with the formula
count({1}distinct AccountID) - count({1<[Scope]-={"-"}>} distinct AccountID)
(note that the formula "count({1<[Scope]={"-"}>} distinct AccountID)" gives a wrong answer: always 0.
Now I would like to see WHAT are those AccountID.
I tried a table with the dimension column "AccountID" and the measure column "Count({<Scope-={"*"}>} AccountID)", but it doesn't work
Neither does the measure column "Only({<Scope={"-"}>} AccountID)" (it gives only one one full-null row)
Neither "IF(Count({<Scope={"*"}>} AccountID))=0, AccountID)" (it gives only one one full-null row)
Thank you for your help
I've got a table that tracks sales across various stores and regions. One of my filters is on the "Store ID". I want to exclude the following three values from my "Store ID" filter:
I can't exclude these in the data load, I have to do it with set analysis. I've tried this but I get an "Expression error" error when writing the "Store ID" filter function in the listbox properties:
={< [Store ID] -={"280-NEI hidden", "414-XUE hidden", "783-VTO hidden"} >}
Hi
I am trying to trigger to Qlik Sense task from c# .net code. Is there any sample code or any useful links which can help me get started?
Many thanks
In March of 2024, Snowflake announced that Hybrid Tables are now in QA.
Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables
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
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)
Hi ,
I was trying get a preview of an image in NPR designer, it runs for along time and fails with in error, while I preview the same with a table, output loads instantly. Could you help us in this regards
Is it possible to do an interval match with two set of intervals? In my fact data, I have the field month end, which looks in the interval Effective Start and Effective Stop. In that same interval match function, can I have the Sales field from my fact data, look in the interval Min Threshold and Max Threshold as well? This is ultimately so I can find out what scale to give my fact data, based on if the sales is between a certain amount and if the sales took place between a certain date range.
Here is what my two tables look like.
Fact Data:
Sales | MonthEnd | Employee |
$40 | 3/30/3024 | A |
$25 | 1/31/2024 | B |
$81 | 1/31/2024 | A |
$78 | 1/31/2024 | C |
$110 | 4/30/2024 | A |
$2 | 4/30/2024 | A |
$179 | 3/31/2024 | B |
$63 | 2/29/2024 | C |
$92 | 2/29/2024 | A |
Dimension/Intervals Data:
Effective Start | Effective Stop | Min Threshold | Max Threshold | Scale |
1/1/2024 | 2/29/2024 | 46 | 100,000,000 | Pass |
1/1/2024 | 2/29/2024 | 0 | 45 | Fail |
3/1/2024 | 3/30/2024 | 51 | 100,000,000 | Pass |
3/1/2024 | 3/30/2024 | 0 | 50 | Fail |
4/1/2024 | 12/31/9000 | 0 | 130 | Fail |
4/1/2024 | 12/31/9000 | 131 | 100,000,000 | Pass |
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!