Can anyone tell me how to find stock coverage for months, for example:

For instance when we are talking about the month Jan where stock is 30.

Hence when forecasting stock we find that when we reach April we are deficit by -26 units.

So I would like to show a formula that divides the remaining stock (i.e 4 in march) by the total stock initially available in Jan (i.e 30 ) to give a value of 0.14.

and this 0.14 gets added to the 3 months (JAN, FEB and MAR) where the initial 30 unit stocks lasted.

Which means in total we get 3.14 (i.e the number the months the stock will last given the parameters)

Hello, 

i have a question regarding scripting in QS.

Lets say I have a table temp. 

[temp]:
Load * inline [
Employee, Boss
100, 105
177, 180
105, 911
400, 402
];

I want to pair all possible relationship. The result should look like this:

Load * inline [
Employee, Boss
100, 105
177, 180
105, 911
400, 402
100, 911];

So in my example 100 -> 105 and 105 -> 911 means that people with the Ids 100 and 911 are in such a relationship. So I want their number to be listed in my result table.

Hope u can help me.

Best regards

Phan Thanh Son

Hi all,

I need some help please.

I have three source tables: Asset, Component and Assessment. An asset is related to multiple components and an assessment is linked one a single asset. 

I've displayed a number of fields in the table from assessment and asset. I would like to add a column with all of the related components but I can't figure out how to do it. It's always displays as blank.

Any ideas would be greatly appreciated. I've attached a screenshot.

Bonjour,

j'ai des Messages d'erreurs HTML tout le temps qui me rends fou pour poster une demande sur ce forum donc je vous prends un screen de ma demande car c'est incompréhensible le problème HTML que j'ai.

Merci de regarder directement en PJ.

Bonne journée et merci

Hi all,

Qlik Sense February 2021 has  a new functionality, regarding the Qlik Sense Engine, that is call Merge, can someone explain how it works?

Below the description:

Merge command script: A new “Merge" command in Qlik script that allows changed data to be loaded into a Qlik application without having to reload the entire data model. Note: This is only the engine functionality and for commercial use it will need additional functionality to allow "partial reload" to be exposed for scheduled reloads vs. via API.

Thanks

Hello,

Does anyone have a good solution to represent a heatmap in QlikSense?

Following the advice here (https://community.qlik.com/t5/New-to-QlikView/Working-with-a-Risk-Map/td-p/1112151) I have created some heatmaps using a pivot table. The result is nice, the only issue is that when filters are applied, rows without values disappear, destroying the square shape.

Is there any way to maintain the rows/form?

before filtering:

after filtering:

Thank you for any suggestions!

Carly

Hi All,

I am using a table - with dimension Service Id,Risk Category Adjusted Score, RISK_MODEL_EXEN_END_DT,

I have to show the table report when [Risk Model End Execution Id] is NULL.

So, I used the expression -

=Only({$<=if(IsNULL([Risk Model End Execution Id]),'NULL','NOTNULL') >}[Risk Model End Execution Id]

but giving me error in expression-

Please kindly assist.

Thanks