Welcome to Qlik Community

Bom dia a todos. 

Tenho uma tabela que mostra o Código de um chamado e todos os status que este chamado passou. 

Eu precisava gerar uma coluna na tabela onde ele calculasse o tempo em que o chamado ficou em cada status (acredito que teria que usar a função ABOVE para realizar esta tarefa. Mas não entendi como ela pode ser usada.

Depois que eu calcular esses tempos totais de cada chamado eu preciso exibir a soma de todos os tempos subtraindo o tempo em que o chamado ficou com o Status 'AGUARDANTO TERCEIROS' 

Não sei se no próprio ABOVE eu posso gerar um IF para que quando a coluna de status for Aguardando terceiros ele coloque o tempo a seguir como ZERO.

Hi Qlik,

I've below two columns in my Dimension value which needs to be format to 00.0% format. 

Ex: 23.1%  (Need one decimal with %).

My original value is 

Any help would be highly appreciated. thanks!

Bom dia, pessoal! 

Estou trabalhando com dados de estagiários da empresa que trabalho e preciso contabilizar em KPIs a quantidade de contratos que irão vencer dentro de 20, 60 e 90 dias. Minha dificuldade é que cada estagiário pode ter até 4 renovações de contrato ou seja, 4 datas de vencimento de contrato. Preciso pegar a última data de vencimento e verificar se está para vencer dentro dos prazos informados. Poderiam me ajudar? Obrigado!

Hello,

I am trying to basically get 12 months of past data and compare that 12 months of data to the current month. After I do that, I need to keep that value.

So, we are currently in September 2021, I need the data dating back from August 2021 - September 2020. Taking that data with the Primary Key of CustomerID, I need to know if from those dates in Aug 2021-Sept 2020, if that CustomerID shows up there, I need to know if it shows up in Sept 2021. If it does, then I will need to count it for September 2021.

The tricky part is then once we are through Sept 2021, we will be in Oct 2021, so from there we need the data dating back from Sept 2021 - Oct 2020, and to compare that past 12 months of data to current month of Oct. Then I need to know which CustomerID's reoccurred in month of Oct from the past 12 months... then storing that data and also keeping the underlying data as well so we can see which ones reoccured.

Anyone know of any way to do this?

Hi Team, 

               I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. 

Tasks : Need to show QVuser name in NPrinting. 

Please refer below my Steps(but i am not getting what i am expected)

1. Created One variable in Qlikview (vPrepared By = 'Prepared By: ' & Subfield(OSUser(),'\',2) 

2. Value is showing as Prepared By: Sakthivel. Selvaraja 

3. Taking this variable in Nprinting Variable. 

4. If I Use this variable in Qlik Nprinting it is showing as NPAdmin(which is Nprinting Admin User)

5. But what my expectation is shown as the same above which is Prepared By: Sakthivel.Selvaraja. 

Will anyone help me to resolve this . It is very urgent

Thanks and Regards, 

Sakthivel.S

Hi everyone,

I am looking for a way to create a country selection by cliking on flag icon. The goal is to allow the user to clik on a flag to filter the country. 

I don't know how to do this, or maybe there is an extansion with this fonctionnality.

Thank you for you're help.

Hello All,

I'm working on a QlikSense app which sources data from multiple views and dim tables created in SQL server. 

When I try to create a flat table I often encounter that few fields does not got with each other, i.e. one field will have a NULL value when other has a value and vice versa for the same id. 

E.g. the id 'Cash receipt gl date' and 'cash app gl date' value but 'Trans Due date' is null.

How, can I overcome this and create a table to have all non-nulls in one row. I want to calculate difference between cash receipt gl date and due date for each id.

Any help is highly appreciated.

Thanks,

I have a QSE Windows implementation that uses SAML authentication against Google Workplace.

When we attempt to update the SSL certificate on the server and paste the new thumbprint in the proxy config, authentication via the SAML Virtual Proxy starts returning a 500 error.

There are no changes to the SAML configuration (which has its own certificate).  Every post I find online references 500 errors related to the SAML certificate specifically.

Has anyone experienced similar issues?  I do not know how replacing the SSL cert on the proxy would cause a problem with the existing SAML configuration.

I understand the SP metadata could change in this scenario, but Google did not require us to upload the SP metadata into the SAML app.

I appreciate any advice/experience/guidance. Thanks!

Hi,

I'm currently trying to implement SAML authentication on our Qlik Sense dev platform.

So I followed the steps described in the Knowledge Base, but I encountered difficulties on the SAML signing algorithm : I need to implement the SHA-256, which requires a certificate, but I can't find what certificate is needed, or where to upload it.

Can somebody help me on this ?

Best regards,

Martin.

I have two tables [Stage 1] and [Stage 2].

I have to concatenate [Stage 2] to [Stage 1], I wrote the following commands but in the result, the values from [Stage 2] is not showing.

First I wrote this 

Concatenate ([Stage 1])

[Stage 3]:
Load *
Resident [Stage 2];

Drop table [Stage 2];

After that i wrote this

[Stage 1]:
Load *
Resident [Stage 1];
Concatenate ([Stage 1])
Load *
Resident [Stage 2];

Drop table [Stage 2];

But in both cases, I am just getting from the stage 1 and stage 2 values are missing, but when I run them separately it works fine.

Plzz help.