@Dataintellinalytics 

I am trying to create a pivot table that shows "Current Sales" and "Previous Month Sales" for each "month year" 

Data:

Expected outcome in Pivot Table

Hope you can help me to solve this requirement 🙂 

Thank you very much for your assistance!

Hi ,

I need to parse and load DB a pipe delimited file having data in the below structure using Talend.

Col1|Col2|Col3

"abc|111"|100|"zzz"

"xyz|222"|200|"yyy"

• Text fields are enclosed in double quotes.
• Few text columns contain the delimiter inside them.

I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).

Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.

Please help.

Thanks

Hi There,

I have two tables, and unfortunately, I should not join them. However, I want to apply the conditions below.  In the model viewer i can see that table 1 and table 2 got  the connection using the ID as primary key.

I appreciate your help to achieve the below condition.

Tabe 1 got raised_date and the primary key is ID

Table 2  got survery_Date and the primary key is ID

and the condition i want is below  

WHERE (table1.raised_date> table2.survery_Date OR IsNull(table1.raised_date);

we are working on building some solution around qlik task log. We want to analyze qlik task log at some interval and parse all qlik task log. Parse log and if there's any failure or warning, we want to highlight on dashboard that will be built on some other tools.

Is there way we can fetch from replicate server (window server), do parsing ?

HI,

I installed QS server (February 24), During the installation I noticed that the computer name that appears automatically does not match the real hostname, I changed it in "Computer host name" field to the real hostname.  

* The computer name that appeared initially is a "Doman Control" or the servers environment. (VMware server that devised for some computers)  

* The installation is a single node environment 

After installation I can't access to HUB or QMC ("This page cannot be reached"). All services was up

* hostname that present in certificate (mmc) does not match to real hostname (appears what was received automatically installation)

I tried to recreate the certificates like here-  Did all the steps, but for no success 

https://community.qlik.com/t5/Official-Support-Articles/How-to-recreate-or-just-delete-certificates-in-Qlik-Sense-No/ta-p/1712692

I ran this command: 
"C:\Program Files\Qlik\Sense\Repository\Repository.exe" -bootstrap -iscentral -restorehostname

And the certificate generation failed, this error was received -

Fatal exception during bootstrap: Newly created client certificate not valid; root certificate can't sign new certificates; 

What else can be done to make it work? I don't know what is the exact problem 

Does the computer name have to be the same as the certification?

Thanks  

***

Some details about system and environment 

1. Windows server 2022
2. VMware server
3. Singe node environment 

Buongiorno a tutti,

sto configurando un server SMTP in un ambiente Cloud, l'SMTP è Office 365 e ho notato che è stata inserita una nuova sezione dedicata per configurarlo. Ho inserito l'ID del tenant, ID Client e Segreto Client (ovviamente sono corretti, generati e copiati direttamente). Ho impostato anche le API permission per Microsoft Graph come indicato qui

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/mc-configure-email-support.htm

Quando salvo le impostazioni in Consolle mi viene mostrato l'errore "Credenziali Errate". 

Per completezza aggiungo che è presente anche una configurazione SMTP normale (fino a poco fa non era presente quella dedicata ad Office 365) che non era funzionante pur essendo configurata esattamente come altre in altri ambienti funzionanti.

Qualcuno può aiutarmi?

Grazie mille

Hi everyone, I have some financial receipt data of customers, and I would like to show how many subscribers exist over time. 

The data consists of a subscriber id, start_date of the subscription, and end_date, depending on the type of subscription (yearly, monthly etc). I also have the amount_paid.

I would like to show a graph with monthName dimension, showing the amount of subscribers of every month. However, if I use monthname(start_date) as the dimension, I lose all the subscribers that have a different start_date, but are still active.

For example, a yearly subscriber that start on January 2024 is still active on February, March etc all the way until January 2025, but his start_date would not reflect that.

With SQL I would just join this table on a list of dates with some rules and aggregate, but I'm wondering what's the best way to create this chart using Qlik analytics.

Thank you very much for your help!