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

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.