I'm working on converting some reports from QlikView over to SSRS.

I'm looking for this calculation in particular (screenshot). I know that REMAINING_HOURS is not an actual column in the OPERATION table in the database and that there's a calculation being done to get REMAINING_HOURS.  I can't find how it's being calculated though.

When I go to Edit Scripts... and look at the Operation tab, I don't see anything referencing REMAINING_HOURS.

I'll also say that Production Schedule is a report within this .qvw and that I'm also not a frequent or seasoned user of QlikView.

Could anyone point me towards where I can view how this field is being calculated?

I am new to administration for Qliksense. I published an app from Dev (QMC2) into Prod (QMC) which overwrote it. That was the wrong app so I am being told to revert back to the previous version of the app. How can I do that? Is it possible?

Hi, I am new to qlik,
I have a pivot table with the dimensions group and subgroup.
the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
( (Num_Subgroup & '- '& Subgroup)).
The problem is that I get a null concatenation in the filter panel.
in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
Can you help me, please.

Hi !

I'm having a couple of issues with my Qlik setup and would greatly appreciate some guidance.

Firstly, my scheduled tasks are failing, and the QMC is displaying the message: "The sequence of events was not completed. Check engine or script logs." In an attempt to resolve this, I've cleared out all logs within the archive logs folder, leaving only three months of history. Additionally, the disk space on the service cluster appears to be sufficient.

Also, for my first daily task that trigger the rest I see that it executed successfully when I see the reload script log but the task status is failed so it doesn't trigger the other tasks.

Secondly, when I try to duplicate apps from QMC, I receive the following error message: "Failed to load Properties. No data found."

Does anyone experienced this before and know what is the cause for this?

Can a background color be set for cells in a trellis container using colormix2?  The charts are histograms and I would like to show deviation from the mean as one of two colors, with white being close to or at the mean.

If it can be done, I would assume it would be in the Master Visualization under Presentation, Styling / General / Background Color / By Expression, but not sure of the correct expression.  For regular tables it's something like:

=colormix2(
(rank(TOTAL column(1))/(NoOfColumns(TOTAL)/2))-1,
rgb(20,20,20),
rgb(100,100,100),
rgb(200,200,200)
)

But this does not work for Trellis Containers.

Please tell me how to correctly write the formula for the measure of a diagram:

If the variable “filename” contains “AP”, then calculate the ratio of the number of values “1” for the variable “Code by Classifier” to the number of the sum of values “1” and “0” for the variable “Code by Classifier”

I tried two formulas, but both did not work correctly, it seems to me:

1. If(WildMatch(filename, '*АР*'), 

   Count(If([Code by Classifier] = 1, 1, 0)) / Count(If([Code by Classifier] = 1 or [Code by Classifier] = 0, 1, 0))

)

2. Count({< [Code by Classifier] = {"1"}, [filename]={"*АР*"} >} [Code by Classifier]) / Count({< [Code by Classifier] = {"0", "1"}, [filename]={"*АР*"} >} [Code by Classifier])

Hi,

I try to concatenate these 2 tables and the fields from the budget one (.xlsx) results in nulls as you can see in the image attatched, where I know there are values. Is there something wrong? 

Many thanks!!!

This is the code: 

Hello,

Just wondering if this "works as designed" or if it's a bug. In Qlik Sense Enterprise, when you go into an app's settings and select Disable Sheet Header, the nav icons "<>" are no longer present. This may seem obvious, but I was told by someone that in Qlik Sense Cloud, they appear in a different location.  So I was wondering if that claim was true and if they should also be visible in Qlik Sense client-managed as well. 

Thank you

Steve

Hello,

Is it possible to have a Qlik Enterprise manager version November 2023 hosted on a Windows server, that manages Linux hosted Qlik Replicate server, version May 2022?

Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:" 
Processing aborted due to error 300002:1355844283; incident 3722464.
to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;

What does this error mean?