Welcome to Qlik Community

I have a field that contains codes for products. some of these products can have more than one code at the same time.

I want to give the user the ability to filter products by Product Code as follows:

get all product which has the following codes:  CodeA and CodeB and (CodeC or CodeD)

Please notice that the product can have either codeC or codeD but not both at the same time, that's why I can not use "and" in addition to the other two code (CodeA and CodeB)

Please advise me on how can I apply this in Qlikview?

Hi,

I Want Different Colors on a Bar Chart(Grouped ) Side by Side with Two dimensions on X_Axis. .I don't want to Stacked Bar Chart.

would like to display Two different Colors like Green and Orange based on the Period Selection with dark and light based on actual versus forecast.

1) The Actual bars (IT & NonIT) should be dark Green and Orange

2) The Forecast bars (IT & NonIT) should be light Green and Orange

Example1: If user select the period 2+10, the Jan and Feb should be dark and the rest will be light colors

Example2: If user select the period 4+8, from Jan to Apr should be dark and the rest will be light colors

Period = 4+8

Will you please verify the attached SampleData and QVW and need your support to achieve on this.

Thanks in advance!!!

Hi

I am trying to put together signals for users based on some kind of data conditions. There will be a set of different rules, that will grow over time. Each rule has a specific explanation text for the user. To handle the data from a multiple rules, a standardized result table is defined.

The problem: How can I show the user the explanations containing the data dynamically.

Example Data (please ignore if the data makes sense or not!)

[Signal_Results]:

ID, Rule_ID, Val1, Val2
1,1,10,20
2,1,30,40
3,2,5,15

[Signal_Static]:

Rule_ID, Explanation
1, Combination A was identified at {Val1} with product {Val2}
2, Temperature Exception was set to {Val1}. Measured {Val2}

Required Output in Qlik Sense table:

ID 1 -> Combination A was identified at 10 with product 20
ID 2 -> Combination A was identified at 30 with product 40
ID 3 -> Temperature Exception was set to 5. Measured 15

In python this could be solved with a print(f”Combination A was identified at {Val1} with product {Val2}”)

How can I dynamically show the descriptions in Qlik Sense without having to output complete descriptions in my Signal_results table?

Thanks for your help!

We just upgraded to 12.5.  We have many documents that the publisher processes nightly.  Some of the documents reload just fine while others do not.  We think there might be something with the documents themselves because the same documents do not reload.  I just cannot figure out what needs changed in the document.

For the documents that the publisher does not reload, when I open them in the client and reload the data, it works just fine.  The same credentials are used to connect to the source DB by the Publisher and the client.

Here is a sample of the Task Log from the publisher:

(12/4/2020 7:47:20 AM) Information: DistributeTask[0124f698-90ce-49cb-9bc2-06b76ef207a6] ("filename.qvw"): TryStart - Starting task. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c. ExecID:a5105d44-c804-47bb-a1bf-b0ea2e1049a4

(12/4/2020 7:47:20 AM) Information: Entering Task Execution.

(12/4/2020 7:47:20 AM) Information: ClusterID=1

(12/4/2020 7:47:20 AM) Information: QDSID=f0893642-d647-b123-dcbf-6e722fedb1b3

(12/4/2020 7:47:20 AM) Information: TaskID=0124f698-90ce-49cb-9bc2-06b76ef207a6

(12/4/2020 7:47:20 AM) Information: ExecID=a5105d44-c804-47bb-a1bf-b0ea2e1049a4

(12/4/2020 7:47:20 AM) Information: MaxRunTime=00:10:00

(12/4/2020 7:47:20 AM) Information: MachineName=QLIK-PUB

(12/4/2020 7:47:20 AM) Information: Task execution max attempts=1

(12/4/2020 7:47:20 AM) Information: Task execution current attempt=1

(12/4/2020 7:47:20 AM) Information: Task Dependencies are OK

(12/4/2020 7:47:20 AM) Information: The task "filename.qvw" is starting

(12/4/2020 7:47:20 AM) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(12/4/2020 7:47:20 AM) Information: Opening "filename.qvw"

(12/4/2020 7:47:20 AM) Information: Allocating new QlikView Engine. Current usage count=4 of 5 (of type non-reader).

(12/4/2020 7:47:20 AM) Information: Max retries:5

(12/4/2020 7:47:20 AM) Information: Attempt:01

(12/4/2020 7:47:21 AM) Information: Opened the QlikView Engine successfully. ProcessID=413596

(12/4/2020 7:47:21 AM) Information: Allocated QlikView Engine successfully. Current usage count=5 of 5 (of type non-reader). Ticket number=50.

(12/4/2020 7:47:21 AM) Information: Loading document "filename.qvw" (0.14 Mb)

(12/4/2020 7:47:21 AM) Information: Physical FileSize=0.14 Mb. Memory Allocation Delta for this file=3.14 Mb. Available Physical Memory Before Open=60247.42 Mb. Available Physical Memory After Open=60243.92 Mb. Total Physical Memory=65535.55 Mb.

(12/4/2020 7:47:21 AM) Information: Attempted to load the document without data.

(12/4/2020 7:47:21 AM) Information: The document was loaded successfully.

(12/4/2020 7:47:21 AM) Information: Document was opened successfully

(12/4/2020 7:47:21 AM) Information: Starting reload

(12/4/2020 7:47:21 AM) Information: The Source Document is being reloaded. DocumentPath=filename.qvw

(12/4/2020 7:47:22 AM) Information: Reloading.

(12/4/2020 7:47:23 AM) Information: Reloading..

(12/4/2020 7:47:24 AM) Information: Reloading...

(12/4/2020 7:47:25 AM) Information: Reloading....

(12/4/2020 7:47:26 AM) Information: Reloading.....

This Reloading... message repeats until the timeout is reached.

In the document settings Generate Logfile is checked.  However, here is the message from the Document Log tab from the QMC:

(Document Log) : No document log found for the specific task run (check if Generate Logfile is enabled).

Any ideas what I should try next?

Hello.

I am creating a simple report in Qlik. I have created the QVD and pulling through the fields into the app.

I am trying to understand how to manipulate the report to show results based off some rules?

An example of some rules I am trying to implement are: 

I have the Transaction Type dimension in the table, as well as effective date and the reporting date (reload date of the report). however I am trying to undestand how to implement those rules into the set anaylsis? Can someone please help to allow me to understand how to do this? I do have some measures, such as Sum (gwp) field. any help please would be greatly appreciated, 

Hola!

Soy nuevo en qlik sense, estoy tratando de activar una licencia ya firmada pero me aparece el error: The license key is not  valid. Ya valide la conexión a https://license.qlikcloud.com Alguien sabe el motivo de este error. Y otra duda alguien sabe como puedo identificar mi partner de Qlik, ya que hace mucho que se realizo la compra de esta licencia.

Les agradezco mucho, Saludos!

Hi team ..

I had Qlik Sense and Qlik Alerting June 2020, I did an upgrade to September 2020. But I have 2 issues.

1.- I scheduled a task in QMC and the alert message is not triggered. I published the app in a stream without success. But, if I triggered the alert from the Web Alerting console .. I receive the email alert.

Any Tips?

2.- I am trying to use “Qlik Alerting Monitoring.qvf”, but when I reloaded the app, I received the following error:

The following error occurred:

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure.

The error occurred here:

Connection: LOAD [token],

 ******* I have the 2 data connections, it was run the BAT file.

Thanks a lot

Gabriel

Hi,

Is it possible to limit the groups or the individuals a user can distribute his alerts to?

e.g. HR users can only distribute alerts to users of the same HR department, Finance users to other finance users, etc.

Kr

Thomas