Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Hello everyone,
I'm looking for an easy to use solution to send my reports by email regularly.
I would like to receive my reports by email once a month and take into account the modifications without having to recreate a sending each time.
In short, I will need a solution to automate the sending of my reports by email.
I've looked into NPrinting, but it's a bit out of my price range.
Do you have another miracle solution for me?
Thanks in advance!
Quentin
Hello Everyone,
Good day!!
i have data like below,.
i would like to do count of ID by ignoring the "App ID" column in script level.
For example, in below if i write code has Count(ID) by group by ID then for ID 250,400 i will get count has 2 and for remaining IDs will get count has 1. But here i would like to ignore the App ID column while doing the count then i will get count has 1 for ID 250.
And this i wants achieve without using distinct , because in my data there are some cases where i have same ID for 2 Names (ex:- Id 400).
Request you to help and let me know if you need any other information
ID | Name | APP ID |
250 | Hari | 102 |
250 | Hari | 105 |
350 | Sai | 103 |
400 | Sat | 104 |
400 | Sham | 109 |
Caros,
Boa noite,
Estou montando um Dashboard para empresa e temos que calcular remuneração de produto vendido, com isso temos varias regras e uma basicamente é...
Tenho a quantidade de Produtos vendidos e o valor unitário desse produto, em certo ponto preciso calcular um fator de Bônus que é baseado no resultado geral da empresa sem considerar resultado individual de produto.
Basicamente é que por um % atingido no calculo geral da empresa 19,51% deveria ter um fator de bônus 0.1 para todos os produtos, porem quando realizo a inclusão na tabela cada produto calcula um % em relação ao 19,51% (uma representação dentro desse universo de 100% (19,51%) com isso alguns ficam com bônus de faixa de 20% quando a empresa ganha pelo geral que seria 19,51%
vou deixar uma imagem para facilitar, eu precisaria que cada produto em sua linha tenha o atributo do fator em relação ao geral da empresa (19,51%)
There is space value in db2 z/os (version 11 CM) columns, our target end is s3 bucket below are our settings in the end point, and we have get weird values in our target csv files such as : "|||"US" , how should I change the settings to get the correct value? Thank you.
Format: csv
Field Delimiter: |
Null value:
Escape character:
Record delimiter:\n
Quote character: "
Hi All,
I have a report name Surgeon Level Report in Nprinting.
How can I schedule reports for each surgeon that means each surgeon will only receive their report. Where their information is highlighted.
Regards
Here at our company NTech, we have developed Analytics projects for customers using Pipefy (https://www.pipefy.com) and Qlik Sense. I didn't find any reading on the topic, so I decided to talk here a little about the use of Qlik Sense to build analytical panels with Pipefy data through GraphQL based APIs.
Qlik Sense has the ability to access data from a wide list of data sources, whether structured or unstructured. To access Pipefy data via the GraphQL API, we use a REST connector, native to the tool. I even wrote an article some time ago called "GraphQL: How to use the Evolution of Web APIs in Qlik Sense" (written in Portuguese).
In this article we will cover the basic concepts, since in Pipefy we have a series of objects such as Pipes, Cards, Phases, Phases History, Labels, Tables, Records, Cards Fields, among others, as well as issues such as data pagination.
A nice thing about Qlik Sense is that we can read all these objects individually and then store them in QVD format (data file in Qlik format) and from these QVDs build the desired views integrating all objects.
Initially we need to define our data loads and logically have the access token already in hand.
1st Load: List of Pipes
We built our GraphyQL Query, according to Pipefy documentation:
{"query":"{ organizations { id name created_at pipes(include_publics: true) { id name } } }"}
Then we created a REST connection, parameterizing it according to the images below:
Inserting API URL and our GraphQL query into the Request Body:
And Inserting you Token in Query Headers:
Then give your connection a name (like "pipes") and save.
Then, create another REST connection, this time to consult the Cards of our Pipe "Gestão de Trabalho Remoto". It is important to know the Pipe ID.
2nd Load: List of Pipe Cards "Gestão de Trabalho Remoto" ID 301532736
Again, we built our new GraphyQL Query, according to Pipefy documentation:
{"query":"{allCards(pipeId:301532736){ edges { node { id title due_date current_phase {name} pipe {id} } } } } "}
In this case, follow all the procedures of the 1st Load, changing only the GraphQL query in the Request Body, and save as the connection with another name (like "cards").
We can make several loads using only a single REST connection, dynamically changing the parameters in the load script, using the WITH CONNECTION statement. However, we will not cover the use of WITH CONNECTION in this article.
Then build the script for the two loads (pipes and cards), through the automatic generation of the connectors (Select Data).
It is necessary to adjust the names of the fields so that the data model does not have conflicts and to generate the associative model correctly.
Here are the scripts for the 2 loads:
Pipe Script:
/*
'
LIB CONNECT TO 'Pipes';
RestConnectorMasterTable:
SQL SELECT
"__KEY_data",
(SELECT
"id" AS "id_u0",
"name" AS "name_u0",
"created_at",
"__KEY_organizations",
"__FK_organizations",
(SELECT
"id",
"name",
"__FK_pipes"
FROM "pipes" FK "__FK_pipes")
FROM "organizations" PK "__KEY_organizations" FK "__FK_organizations")
FROM JSON (wrap off) "data" PK "__KEY_data";
[organizations]:
LOAD
[id_u0] AS organization_id,
[name_u0] AS organization_name,
[created_at] AS organization_created_at,
[__KEY_organizations],
[__FK_organizations] AS [__KEY_data]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_organizations]);
[pipes]:
LOAD
[id] as pipe_id,
[name] as pipe_name,
[__FK_pipes] AS [__KEY_organizations]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_pipes]);
Left Join(pipes)
LOAD
organization_id,
organization_name,
[__KEY_organizations]
RESIDENT [organizations];
DROP TABLE RestConnectorMasterTable;
DROP TABLE [organizations];
DROP Field [__KEY_organizations] From [pipes];
'
*/
Cards Script:
/*
LIB CONNECT TO 'Cards';
RestConnectorMasterTable:
SQL SELECT
"__KEY_data",
(SELECT
"__KEY_allCards",
"__FK_allCards",
(SELECT
"__KEY_edges",
"__FK_edges",
(SELECT
"id" AS "id_u0",
"title",
"due_date",
"__KEY_node",
"__FK_node",
(SELECT
"name",
"__FK_current_phase"
FROM "current_phase" FK "__FK_current_phase"),
(SELECT
"id",
"__FK_pipe"
FROM "pipe" FK "__FK_pipe")
FROM "node" PK "__KEY_node" FK "__FK_node")
FROM "edges" PK "__KEY_edges" FK "__FK_edges")
FROM "allCards" PK "__KEY_allCards" FK "__FK_allCards")
FROM JSON (wrap off) "data" PK "__KEY_data";
[cardpipe]:
LOAD
[id] as pipe_id,
[__FK_pipe] AS [__KEY_node]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_pipe]);
[current_phase]:
LOAD
[name] as current_phase_name,
[__FK_current_phase] AS [__KEY_node]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_current_phase]);
[cards]:
LOAD
[id_u0] as card_id,
[title] as card_title,
[due_date] as card_due_date,
[__KEY_node]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_node]);
Left Join(cards)
LOAD
current_phase_name,
[__KEY_node]
RESIDENT [current_phase];
Left Join(cards)
LOAD
pipe_id,
[__KEY_node]
RESIDENT [cardpipe];
DROP TABLE RestConnectorMasterTable;
DROP Table [cardpipe];
DROP TABLE [current_phase];
DROP Field [__KEY_node]from cards;
*/
Once the data model is loaded, it will look like this:
And finally we can make our panels, like the example below:
That's it! See you the next!
Hands-on workshops are back at QlikWorld Online!
If you are new to Qlik Sense Enterprise SaaS, you might want to check out my hands-on session:
Introduction to Qlik Sense Enterprise SaaS
You will have access to our SaaS environment as well as assistance from a team of Qlik Experts.
Looking forward to seeing you there!
Hi,
I'm asked how to delete 7,000 files automatically at this post: https://community.qlik.com/t5/Deployment-Management/How-delete-7-000-files-inside-SaaS-DataFiles-Folder/m-p/1760320/highlight/true#M18887. The solution works great, but it just operate with Personal Space.
How can I operate with other spaces? Where I can find qix/datafiles parameters ?
Tks
Pedro
We've noticed a strange issue today. Underscores in straight tables are not always being displayed in ajax access point. However they do display in the Qlikview application.
I've tried changing font, font size, object style but nothing seems to help.
See screenshot from accesspoint. You'll notice the listbox works fine. Even the straight table without lines has the same problem.
I have attached a sample qvw. Any suggestions would be appreciated.
MVP
22805MVP
8659Employee
8659MVP
8201MVP
7991Employee
6509MVP & Luminary
5380MVP
5189MVP
4418Employee
4113Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.
Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’
Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.