Hello,

I have been having major issues with Qlik Sense Desktop installations. Initially, I kept getting various errors so I tried to uninstall without much luck. After multiple attempts, I deleted folders from my laptop, cleaned the registry and tried to reinstall. It is somehow not seeing Qlik Sense as uninstalled from my laptop no matter what. I am attaching the log and hoping someone from the team can assist. Thanks!!!

Hello all,

Let's say you have created a folder data connection in a Qlik Sense application.

And there are 5-10 developers working on QS app development.

How do you give multiple developers access to a data connection? Example of a security rule please?

Hi to all!!

On the next images a screenshots of a connection that change the number of sheets / pages form a HTML that I receive every day.

Any ideas on how to configure the connection so every time gets all the sheets / pages?

Important to mention that on the last image a yellow segment that shows how the info finish. On the first column the las line is always a *

As always thank you very much for your help and Ideas!!!!!!

Sometimes I get 6 sheets / pages

Sometimes I get 3 sheets / pages:

Always the last line of the firs column is *

any ideas?

Hi,

I have read various post but to no avail and wondered if anyone could help please.

I have the below expression:

                     Count({<'Document Status'={'30'},'Document Version'={'0'},'Return Due Date'={'<>Null()'}>}distinct([%Key_DIR]))

i would like to add another criteria where

([MB51.ReportDate]-[Return Due Date])<0

Thanks

Hello,

I have been asked a question, if an user tells this application is slowing down and it was not before, then what should be the approach to resolve it. 

Buenas,

Estoy intentando conectar Qlik sense con OSticket.

A la hora de sacar estadísticas me salen muchas NAs (null) porque la ubicación del ticket puede estar en una de 6 columnas según la zona. Cada zona es una columna.

Mi idea es concatenar las 6 columnas en una pero no se como hacerlo. En tableau si que sabria hacerlo pero lo tengo que hacer en QLik.

Once every few reloads I get this error. And this only happens in the DLE while reloading. Any suggestions on what might be causing this and/or which log files to look at?

And after this happens my user is no longer authenticated so all of my app windows close and I have to log in again. This was happening with one of the early 2019 releases and I just updated to the June 2019 release.  And it is still happening

This totally interrupts my workflow and so far seems totally unpredictable. Any suggestions or discussion would be greatly appreciated. I'll be happy to do any digging.

Hi Team,

I need one help from your side. I have two tables, table 'A' and table 'B' if we load the data into data model, there should not be any link between both tables A and B. In the front end, we need  a year and month column based on year and month column both table data should be changed.

Note: I am using the below expression to combine both the data tables, but year and month is coming double time. If you have any better suggestion, please advise me. 

=Date([Sales date]) &' - '& date([Profit Date])

Regards,

Irshad Ansari

Hallo,

ich befasse mich erst seit dieser Woche mit QlikView, bitte nicht gleich den Kopf abreisen wenn meine Frage vllt. komisch klingt.

Ich habe ein .qvw Datei erhalten in der Daten aus einer qvd-Datei gelesen und aufbereitet werden.

Darunter ist ein Diagramm das Werkzeugnummer, Material-ID und 3 mit Funktionen errechnete Spalten enthält.

Eine dieser Spalten enthält diese Funktion:

"=SUM(Einteilungsmenge) / SUM(total <Werkzeug> Einteilungsmenge)".

Meine Chefs hätten jetzt gerne genau dieses Diagramm als Tabelle in einer QVD-Datei.

Ich habe also versucht im Skript dieses Diagramm als Tabelle nachzubauen und zu speichern.

SET localPath = 'C:\Users\HO\Documents\';
ArticleMix_tmp:
load Material_ID, LEFT(Material_ID,5) as Werkzeug, Materialname, Einteilungsmenge
FROM $(localPath)LP_Daten(qvd);

Testtabelle:
load Werkzeug, Material_ID,
SUM(Einteilungsmenge) / SUM(TOTAL  Einteilungsmenge) AS ArticleMix
Resident ArticleMix_tmp;

STORE Testtabelle INTO $(localPath)ArticleMix_Test.qvd(qvd);

DROP ArticleMix_tmp;

********************************************************

Jetzt bekomme ich so aber immer einen Fehler "Error in Expression: ')' expected".

Wie ich vermute liegt das an "TOTAL", da man das wohl nicht im Skripteditor verwenden kann!?

Jemand eine Idee wie ich das sonst lösen kann?

Danke