Hello dears!

Please tell me how to hide a column in pivot table which has only zeros (nulls) - see example below. I know about unchecking button "include zero values" and "include null values". Normally, if I have only one measure, it works correctly, but I have to add one more measure (which has a lot of null values for prior months). 

In this particular case I want to hide month "2018-01" in measure "LM growth"

HI Devs,

I have a pivot table in Qlik Sense as below. I wish to hide those Obj IDs in the table that have the total value for the 'Calculation ' field as 0. (Totals is the subtotal field i got when i added data to the pivot table)

Here I would like to see only the values for Obj ID 10002.

Thanks.

AJ

Hello Everyone,

We are trying to calculate values of certain KPIs at script side and storing those values into Qvd but we are facing challenge in that, need help on that.

Below is the script which we have written and with that we are not getting appropriate output:

LET rowText = NoOfRows('Threshold');

for i=1 to $(rowText) // loop through every row

let vMETRICID = Peek('METRICID',$(i),'Threshold'); 
Let vDOMAINID = Peek('DOMAINID',$(i),'Threshold');

Let vBrkFixReslDen='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0,1},isInternal={1},ToolType={1}>}Task)';
Let vBrkFixReslNum='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0},isInternal={1},ToolType={1}>}Task)';

Set vBrkFixRespDen='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0,1},ToolType={1}>}IncidentID)';
Set vBrkFixRespNum='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0},ToolType={1}>}IncidentID)';

Let SLA_M1 = '=Pick(match($(vMETRICID),51,61),
Num($(vBrkFixReslNum)/$(vBrkFixReslDen),''##0.00%''),
Num($(vBrkFixRespNum)/$(vBrkFixRespDen),''######.0'')

)';

SLAValues:
Load '$(vMETRICID)' as Metid, '$(vDOMAINID)' as Domid, '$(SLA_M1)' as SLAMI,
'$(vMETRICID)'&'|'&'$(vDOMAINID)' AS SLAID
AutoGenerate 1;

LET vQVDexists = if(FileSize('lib://QVD_DATA/SLAValues.qvd') > 0, 1, 0);

IF vQVDexists = 0 THEN
Store SLAValues into [lib://QVD_DATA/SLAValues.qvd](qvd);
Else
Concatenate(SLAValues)
Load * FROM [lib://QVD_DATA/SLAValues.qvd]
(qvd) where Not Exists(SLAID);

Store SLAValues into [lib://QVD_DATA/SLAValues.qvd](qvd);
End if;
Drop table SLAValues;
Next

in the SLAMI column of SLAValues table instead of getting the result value we are getting a string with formula in it like:

"=Pick(match(51,51,61),
Num(Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0},isInternal={1},ToolType={1}>}Task) / Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0,1},isInternal={1},ToolType={1}>}Task),'##0.00%'),

Num(Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0},ToolType={1}>}IncidentID) / Count({<DOMAINID={'1'},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0,1},ToolType={1}>}IncidentID),'######.0')

)"

but instead of formula we want to get the calculated value in this column or else if we can get the value in the chart/table when we select this column that should also work.

Looking forward for help.

Regards, Tauceef

Hi,

I want to get the count of each customer based on the utilization percentage and group the count under each percentage range (ie, <50% , 50-70%, 70-90% and >90%). Attached the input data and straight table.. Please share your inputs on how to get this designed. Thanks!

Attached the screenshot  (count may not be accurate in the screenshot)

We want to migrate from single node architecture to a multinode architecture.

We start with a single node server where we access to the dashboards, schedule and development. This server has an associated URL from which we successfully access both the qmc (https://mydomain.com/qmc) and the hub (https://mydomain.com/hub).

Due to customer demand we want to move to a multinode server

 adding a consumer node to the central node. From now on we will refer to the central server as "Central" and the consumer server as "Node".

We successfully install the Node server according to (https://help.qlik.com/en-US/sense/June2017/Content/Videos/Videos-join-node-to-cluster.htm) and we link it correctly to the Central server by activating Consumer Node Services (Repository, Engine and Proxy):

We have configured the two proxies the same and they are in Running status.

Then we have done several tests to ensure that access to the applications is configured correctly:

 Access applications with load balancing through a virtual proxy called uve:

And we link the two proxies:

This virtual proxy is what we use in a single server configuration, we just added the load balancing node and the Node as its associated proxy.

We have also enabled the load balancing rules which give us the following accesses:

If we go to https://mydomain.com/uve/hub and open the apps, we open them correctly with both nodes. Checking the logs we see that he has opened two apps with one node and two apps with another node.

From this point we want to access some apps only through the "Central" node and others through the "Node" node. To do this we want to do it through virtual proxies.

• When the URL is https://mydomain.com/ we will access the "Central" node
• When the URL is https://mydomain.com/uve we will only access the "Node" node

If we look at the configuration of virtual proxies:
Only use the Central proxy as Load balancing:

With the associated Central Proxy:

And if we look at the virtual proxy / uve we see that we have updated it to:

Only with the node proxy as load balancing:

With the associated Node and Central Proxys:

If we access the URL of the app with the node proxy, if the load balancing rule allows it, then we access the application correctly.

But if we want to access the hub through the Node proxy: https://mydomain.com/uve/hub

We get the following error:

HI Devs,

I have a complex report ready and I have a monthyear filter.

When I select a particular MonthYear value in the filter, I want the selection to include all the previous MonthYear values upto the current selection.

ex: My MonthYear filter has values Dec-2019,Nov-2019,Oct-19,Sep-19,......starting from Jan-2013

When I select Oct-19 in my filter, all the MonthYear values from Jan-2013 to Oct-19 should be selected.

I do not wish to change anything on my pivot table report. 

Is there a way to way to achieve this using filters alone?

Hi,

I am creating a gantt chart but the axes displays year 1900 instead of current year from data. Please let me now what needs to be changed. Thanks!

Hi,
I need Your help, Guys. I tried to use Generic Load to reversal my table with Attributes. Unfortunately, it's about 80 000 000 records, and system  memory is full. I want to store every table to QVD in Generic Load, and then join every table from qvd, not from memory. My script looks now like that:

Attributes:
Generic LOAD
%OrderBookingKey,
Code,
Value
Resident Attributes_tmp;

Set vListOfTables = ;
For vTableNo = 0 to NoOfTables()
Let vTableName = TableName($(vTableNo)) ;
If Subfield(vTableName,'.',1)='Attributes' Then
Let vListOfTables = vListOfTables & If(Len(vListOfTables)>0,',') & Chr(39) & vTableName & Chr(39) ;
End If
Next vTableNo

CombinedGenericTable:
Load distinct %OrderBookingKey Resident Attributes_tmp;

Drop Table Attributes_tmp;

For each vTableName in $(vListOfTables)
Left Join (CombinedGenericTable) Load * Resident [$(vTableName)];
Drop Table [$(vTableName)];
Next vTableName

Store CombinedGenericTable into [lib://Transformed (win-f2om7p4maoo_followup)/Attributes_transformed.qvd] (qvd);

I think I should store the "little tables" to QVD before creating CombinedGenericTable, but I don't know how can I load all of them to my Generic table.

Thanks in advance for Your help!

I am trying to use Autonumber() to generate a number for Cost and Customer.  I have sorted already sorted in the order needed but I do not want the Autonumber to repeat when multiple Customers have the same cost.  How do I end up with an Autogenerated Number equal to the number of rows with no duplicates when the cost is the same.  Example: If I have 4000 rows  I want my ending AutoNumber to be 4000 not 3500 with duplicates.  Hopefully, that makes sense.  Any help will be greatly appreciated.