Welcome to Qlik Community

Hi guys I need your help about incremental load.

DATE             ID            MONEY              ATRIBUT1        ATRIBUT2
1.8.2020. 141306          70                        306                       1507

Load is going every day from beginning.

Let's start
Someone changed for atribut1 on 2.8., instead 306, put 309
Standard load:

load
date,
id,
money,
atribut1,
atribut2
from table1.qvd: 1;

store table into table1.qvd
DATE                 ID                      MONEY                 ATRIBUT1              ATRIBUT2
1.8.2020. 141306                        70                             309                          1507
2.8.2020. 141306                       100                            309                          1507

We see atribut 1 for 1.8. changed also.

To avoid this situation I made incremental load.

table:
load
date,
id,
money,
atribut1,
atribut2
from table1.qvd: 1 where date<today()-1;

concatenate(table)
load
date,
id,
money,
atribut1,
atribut2
from table1.qvd: 1 where date=today()-1;

store table into table1.qvd

DATE               ID                                         MONEY                      ATRIBUT1                 ATRIBUT2
1.8.2020. 141306                                           70                                   306                          1507
2.8.2020. 141306                                       100                                    309                           1507

Atribut1 is not changed and it is okay.

Now I need situation. If someone on database changed atribut1, and I want it doesn’t affect older data, I will use this incremental, but what if someone change money on 1.8. How to put new calculation?


DATE             ID                                          MONEY                            ATRIBUT1                      ATRIBUT2
1.8.2020. 141306                                       80                                        306                                     1507
2.8.2020. 141306                                    100                                        309                                      1507

How to have 80 instead of 70 at 1.8., if I use incremental load?

thanks

I'm currently working on a project where we are getting a single table to be turned into a report. The fields include a contract code, the parent contract code, and the child contract code(s). We are trying to show the data in a hierarchical manner as a table, similar to how Excel can include plus signs to the left of the data. We have tried several different methods, including pivot tables, drill down dimensions, hierarchy and ancestor tables, and even just multiple tables to try to get this right. Nothing quite works. Has anyone else had to do anything like this?

I am trying to download an attachment from an email. I put in my credentials and I get this pop up:

I have signed in with my credentials since I am an admin on the server and I even signed in with a service account which also is an admin on the server.  The connectors were installed and executed with a login with admin rights. So.. how do I grant access to this connector?

Hi there,

I have to use a P&L pivot to represent different KPIs. The problem is that with P&L I can just set the colors for one performance, but I have to set:

• Green color for CapEx < 0 and Red color for CapEX > 0,  
• Green color for another KPI when is > 0 and Red color when is < 0

is set analysis a possible solution ? or maybe it can be the style csv that I use for  style template formt ?

thanks for your time 

Hi, I'm having this weird issue again where I do a distinct count for measure and a drill down of dates for dimensions, but the weekly count is different from the count added separately by date. 

I don't have a pic for the individual dates, but I added them twice separately after selecting W32, and got 86 (which is correct). 

The measure formula I use is Count({<PolicyStatus = {'Policy - Accepted'}>} distinct EventNumber)

My data is formatted so that there could be repeating event numbers with the same status and dates. Like I could have two entries with the same eventnumber, status, and date

Hola,

Cuando abro Qlik Sense escritorio me sale el siguiente error:

'error de autenticación en el servidor seleccionado. Asegúrese de que su conexión a Internet funcione correctamente e inténtelo de nuevo.

Adjunto la imagen.

No me sale ni para poder hacer el inicio de sesión, el mensaje de venta cuando le doy una sesión de inicio, pero no puedo medir mi usuario y contraseña.

La versión que tengo es Noviembre 2019 parche 13.

muchas gracias

Un saludo

 Hi Team,

Below is the scenario.

Expression in table : 

=If(Date([Consumption Date])=Date([Scheduled Date]),Date([Scheduled Date]))

Expression in KPI:

=sum(If(Date([Consumption Date])=Date([Scheduled Date]),1))

There are 12 records in table. But in KPI i am getting the value as 36. I tried with count expression as well.

=count(If(Date([Consumption Date])=Date([Scheduled Date]),Date([Scheduled Date]))

Can anyone help me out here with the correct expression to get value as 12 ?

Estou realizando a importação de uma planilha para o Qlik sense e ele me mostra que trouxe 172 linhas quando eu faço a extração e gero um QVD, 

Entretanto ele só está trazendo paraa tabela no painel 65 linhas. Eu acredito que ele esteja agrupando linhas que sejam totalmente iguais.

Tenho os campos

Fabricante
Saldo
Localidade

Como eu posso fazer para que o Qlik Sense traga os campos, mesmo os iguais em linhas diferentes, sem este agrupamento??

Hi. 

I have a multi kpi and I'm using a value list for the dimension. In the measures, I have specific calculations for each valuelist item, but I was wondering if it is possible to set a different format pattern for one of them because I have a ratio field that is 0.56 but it rounds to 1.

Hi all, 

Would like to have a flag in a date filter pane, eg. 1 = the most actual available date. The formula below works fine:

=If(Datum = Date(Floor(ReloadDate)), 1, 0)

But when I want to use it as a bookmark, and have ticked "1" then it does not work properly. Reason: In the filter will be saved the last actual date, so this date will remain for every new date (eg. below 28.07.2020). 

Has anybody an idea how to implement it dynamicaly in the bookmark, so by clicking on it you always have the actual date?

Thanks.