I'm creating a vehicle utilization dashboard, but most importantly, need to show non-utilization. The data source only contains the dates that someone signed in as using a vehicle, so currently the only "non-utilization" I can show is if someone signed in, but then didn't input mileage (as it'd be 0). I have a calendar table on another database (diff server) and thought I could create a 1=1 relationship so every vehicle would have 365 entries....and then all the "null values" would be my new "non-utilization" count. I've accomplished this before in SQL if they're on the same server, but I honestly have no idea how to do this in QLIK. 

I loaded the vehicle usage data and then loaded the calendar separately. I named both date columns the same knowing QLIK will make a connection, but it doesn't actually give me the desired result. I am new to QLIK, so not super savvy with QLIK Script or how to accomplish this. Any help is appreciated! 

Hi Gurus,

I am trying to go from 1 table in source to Many tables on the target database. source is SQL and target is Oracle. What is the are some of the patterns to achieve this? The table schemas are different b/w source and target.

Thanks!

-

Hello everybody!
I have a question that probably has a very simple solution... as usual...

I need to count how many times a value repeats within 24 hours.

Normally, in Excel, a simple formula is enough.

COUNTIF(Table[PHONE],[@PHONE],Table[DATE],"<"&[@DATE]+1)

I tried everything in Load or SetAnalysis but without success.

I can't do it in base because it's a REST API.

Any idea?

Boa tarde

Estou buscando por endereços a Lat e Long  na api  da google ( Geocode ), alguns me trazem o resultado esperado outras não retornam os dados. 

Vou mandar alguns print do script e o resultado.

Se alguém conseguir me orientar como solucionar, Agradeço!

hi Team 

1 we are plan to migrate qlik sense application from windows server 2012 R2 STD to new server 2019 R2 STD  , 

is there any specific tool we need to use for migration to keep our existing configuration on new server ? 

product details : 

qlik sense - 14.20.5 (old server)

qlik nprinting - 21.14.4.0 (old server)

2 what if we directly upgrade from 2012 R2 to  2019 R2 is there any configuration changes required after upgrade ?

and is there any specific  file we need to backup ?

Boa Tarde!

a aplicação no espaço pessoal funcional, mas quando publicamos em um espaço gerenciado, não aparece informações.

1. Espaço Pessoal.

2. Publicado.

Desde já agradeço, 

Hello,

I have installed Qlik Sense Enterprise on-premise in the customer environment. The customer wants me to generate CSR from Qlik sense but I don't know the steps on how to create the CSR from Qlik Sense. I tried looking at the community but unfortunately, the information is archived.

I will appreciate it if anyone can share the steps to generate CSR from Qlik Sense.

Thanks and Regards
Vaibhav 

Hi

We need to achieve high availability in our deployment. For this we have installed QS on two servers and made them central node and failover node. Along with this we had installed Postgres SQL on a different server there also we have installed Postgres SQL on two servers.

Now we are also having NPrinting & GeoAnalytics in our deployment. We want to achieve HA in these two also. So I have installed both tools on two servers, but I am unable to get how to do data replication in both case of NPrinting and Geo Analytics. We have to setup such environment that in case one server of Nprinting fails so it will get transferred to another server and reports can be downloaded and same case with Geo Analytics, if one server of Geo analytics fails Map can populate from another server.