We are migrating our Qlikview processes to Qliksense and noticed a problem in the way Qliksense interprets data type of an attribute.

Our database table (mytable) has Department as STRING (varchar). It contains numbers, strings, mixed values, numbers with leading zeros ..etc. When we load this table into Qlikview, Qlikview automatically translates number (like) values into numbers and varchars into text. For example using:

LOAD Retailer, Department from mytable; 

Department values like 011, MISSY, 230-20,35 are loaded in QV:

• 11 (number right justified)
• MISSY (text left justified)
• 230-20 (text left justified)
• 35 (number right justified)

 We are not using any function to load Department at all in QV.

When i translated the same load in QS, the same values are treated as text only and are right justified:

• 011 (text left justified)
• MISSY (text left justified)
• 230-20 (text left justified)
• 35 (text left justified)

This mismatch has created a problem for history data where QVD loaded off Qlikview had 11 as Department value, but now in QS it is 011. 

Is there any way to have Qliksense load such data in the same way as Qlikview does?

Hi everyone, 

Please I need your help. I have a field called Region with values Asia, EMEA, Latin America & North America. I am showing the sales for each region over time on a line chart. Is it possible to create a 5th line that shows the total of all sales as "CompanyTotal" on the line chart? A sample of my data and line chart is shown below. 

Hey Qlik Community! 👋

We're facing a bit of a challenge trying to display multi-line comments captured in a Vizlib Writeback table within a standard Vizlib table.

Here's the situation:

• We have user comments being entered into a Vizlib Writeback table. These comments can span multiple lines (using line breaks within the writeback field).
• When we simply add the comment field from the Writeback table to a regular Vizlib table, all the lines get squashed into a single, long sentence, making it really hard to read.

We've considered a couple of workarounds, but neither feels ideal:

1. Direct Field Inclusion: As mentioned, this results in the dreaded "wall of text." 😫
2. Using a Separator Character ("|"): While this technically works to delineate comments, it's not user-friendly. People might forget to add the separator, leading to data integrity issues. Plus, it would require extra scripting or a separate table to properly parse and display the comments in a readable stacked format. ⚙️

So, our question for the brilliant minds here is: Is there a way to display these multi-line comments from the Vizlib Writeback table in a standard Vizlib table with the line breaks preserved (i.e., stacked on separate lines) without relying on users to manually input a separator character?

We're open to any suggestions or insights you might have! Thanks in advance for your help! 🙏

Hi All, 

I have a Vizlib Pivot table chart and I want to sort the Product dimension as 1-Deal, 2-Hubbing, 3- ITFS and so on.

when I am making month selection it is changing the sorting order. Please find below the snippet when i am selecting Apr25 as period. Can anyone please help and suggest.

Thanks in advance. 

I'm not seeing posts in my local timezone anymore but I do believe that I used to?

I made a post, I suppose 12:02 GMT+1 (i.e. CEST here in Stockholm, Sweden) but I see it in the listing with a very different timestamp:

My community settings seem correct:

Has the forum stopped respecting time zone settings for users? Or am I just confused and it has always been this way?

With the output from a straight table, you can see in the pic1 below how I set up the sent email.  However, Qlik will not give an output, see pic2.  Then I put ion this HTML script, it's below the pics, and it will only return the 1st row from the Get Straight table output array.  If I change the index from [0] to [*] it fails as well.  I am not an html master by any stretch and even utilized Chat GPT which recognized an issue with the loop, but it failed multiple times (it's pasted below the 1st HTML section) in producing script that would work. Also there was mention of a template engine that Qlik uses, anyone know which one it is?  Anyone have any thoughts on how to fix this?

pic1

pic2

HTML produces 1 row only, changing index to [*] fails:

Hello,
I am using Qlik Alerting 2024 Nov SR1 on a Windows Server 2016 environment and I am trying to run it using the HTTP protocol. Despite trying several approaches, I haven’t been able to get it working, so I am reaching out for assistance.

Environment:

• Qlik Alerting Version: 2024 Nov SR1
• OS: Windows Server 2016
• Node.js: 20.17
• MongoDB: 6.0.17

Objective:

• Service URL: I want to use the HTTP protocol and access the service with an IP address like http://192.168.0.239:4551/#/login/.

What I Have Tried:

1. Editing the default.json file

   • I’ve modified the C:\Program Files\Qlik Alerting\config\default.json file, but nothing worked.
   • HSTS Settings: Tried setting hstsMaxAge to 0 ( or 31536000)
   • Gateway Settings: Changed localhost to the actual IP address.
     • "https": false
     • "trustProxy": 1 ( or o )
   • allowInsecure Settings: Added "allowInsecure": { "http": false, "TLSv1": false, "TLSv1_1": false, "TLSv1_2": true }.

2. Clean Reinstall

   • I uninstalled Qlik Alerting and MongoDB completely, and did several clean installations. Unfortunately, the issue persists.

Current Situation:

• I can access the service via http://localhost:4551, but for integration with Qlik Sense or access from clients, I cannot use localhost.
  • 127.0.0.1 works, but external IPs or domain names do not work.
• Issue Observed:
  • When I initially call the URL, the network tools show that static files are being loaded, but the address changes. For example, when calling http://192.168.0.239:4551/, it switches to https://192.168.0.239:4551/static/js/main.ea39ec04.js, causing an error.
  • Console error:
    GET https://192.168.0.239:4551/static/css/main.bde10e2a.css net::ERR_SSL_PROTOCOL_ERROR 192.168.0.239/:1

    
     

Request:

If anyone has experience running Qlik Alerting with HTTP protocol and IP address, I would really appreciate your help or suggestions on how to make this work.

Thank you!

I am writing my own API and one of its endpoints needs to fetch data from a qlik app. My users authenticate against my API using a JWT token. I configured a virtual proxy in qlik to connect to qlik using the same token. This works, but only once per token. This is my code:

private string GetTokenFromAuthHeader()
{
    string authorizationHeader = HttpContext.Request.Headers.Authorization;
    if (string.IsNullOrEmpty(authorizationHeader) || !authorizationHeader.StartsWith("Bearer "))
    {
        throw new InvalidParameterValueException("No bearer token found");
    }
    return authorizationHeader.Substring("Bearer ".Length).Trim();
}

private static ILocation ConnectToQlikUsingToken(string token)
{
    ILocation location = Location.FromUri($"wss://{server}");
    location.VirtualProxyPath = "myproxy";
    location.AsJwtViaProxy(token, false);
    return location;

}

[HttpPost(Name = "myEndpoint")]
public IActionResult Post()
{
    string token = GetTokenFromAuthHeader();
    var location = ConnectToQlikUsingToken(token);
    string appName = "my-appname";
    var appIdentifier = LocationExtensions.AppWithNameOrDefault(location, appName);
    Qlik.Engine.ISession session = Session.WithApp(appIdentifier, SessionType.Default);
    var app = location.App(appIdentifier, session);
    var result = app.EvaluateEx("=Count(Task.Category)");
    return Ok(result);           
}

Everything works well for the first request. But when I send another request to my API, authentication fails throwing this error:

      System.Security.Authentication.AuthenticationException: Authentication failed.
         at Qlik.Engine.Communication.QlikConnection.AwaitResponseTask[T](T task, String methodName, CancellationToken cancellationToken)
         at Qlik.Engine.Communication.QlikConnection.AwaitResponse(Task task, String methodName, CancellationToken cancellationToken)
         at Qlik.Engine.Communication.QlikConnection.Ping()
         at Qlik.Sense.JsonRpc.GenericLocation.DisposeOnError(IDisposable o, Action f)
         at Qlik.Engine.LocationExtensions.Hub(ILocation location, ISession session)
         at Qlik.Engine.LocationExtensions.AppsWithNameOrDefault(ILocation location, String appName)
         at Qlik.Engine.LocationExtensions.AppWithNameOrDefault(ILocation location, String appName)

Obtaining a new JWT token and using this works. Why? Do I need to close the session somehow? I tried Dispose() on the location and app but it does not help. Any ideas?

Hi,

What would be the best way to achieve the following:

User selects 2025-Q1, 2024-Q4, 2024-Q3, 2024-Q2

User wants to see the Sum(Sales)

But now User wants to compare it to  2024-Q1, 2023-Q4, 2023-Q3, 2023-Q2

This should also work when 2 or 3 Quarters are selected

2025-Q1, 2024-Q4, 2024-Q3 vs. 2024-Q1, 2023-Q4, 2023-Q3

2025-Q1, 2024-Q4 vs. 2024-Q1, 2023-Q4

Dataset:

SalesData:
LOAD
    Date(Date#(Date, 'DD/MM/YYYY')) as Date,
    Sales,
    Customer,
    Year(Date#(Date, 'DD/MM/YYYY')) as Year,
    Month(Date#(Date, 'DD/MM/YYYY')) as Month,
    'Q' & Ceil(Month(Date#(Date, 'DD/MM/YYYY')) / 3) as Quarter,
    Year(Date#(Date, 'DD/MM/YYYY')) & '-Q' & Ceil(Month(Date#(Date, 'DD/MM/YYYY')) / 3) as YearQuarter,
    Year(Date#(Date, 'DD/MM/YYYY')) - 1 & '-Q' & Ceil(Month(Date#(Date, 'DD/MM/YYYY')) / 3) as YearQuarterCompare
INLINE [
    Date, Sales, Customer
    01/01/2025, 22, 1
    02/01/2025, 33, 1
    01/02/2025, 44, 1
    02/02/2025, 55, 1
    01/03/2025, 66, 1
    02/03/2025, 77, 1
    01/04/2025, 88, 1
    02/04/2025, 99, 1
    01/01/2024, 91, 1
    02/01/2024, 92, 1
    01/02/2024, 81, 1
    02/02/2024, 82, 1
    01/03/2024, 71, 1
    02/03/2024, 72, 1
    01/04/2024, 63, 1
    02/04/2024, 64, 1
    01/05/2024, 54, 1
    02/05/2024, 53, 1
    01/06/2024, 43, 1
    02/06/2024, 42, 1
    01/07/2024, 31, 1
    02/07/2024, 32, 1
    01/08/2024, 21, 1
    02/08/2024, 23, 1
    01/09/2024, 12, 1
    01/09/2024, 13, 1
    01/10/2024, 101, 1
    02/10/2024, 103, 1
    01/11/2024, 113, 1
    02/11/2024, 114, 1
    01/12/2024, 125, 1
    02/12/2024, 126, 1
    01/01/2023, 133, 1
    02/01/2023, 134, 1
    01/02/2023, 143, 1
    02/02/2023, 144, 1
    01/03/2023, 154, 1
    02/03/2023, 155, 1
    01/04/2023, 166, 1
    02/04/2023, 167, 1
    01/05/2023, 178, 1
    02/05/2023, 179, 1
    01/06/2023, 181, 1
    02/06/2023, 182, 1
    01/07/2023, 191, 1
    02/07/2023, 192, 1
    01/08/2023, 67, 1
    02/08/2023, 69, 1
    01/09/2023, 79, 1
    01/09/2023, 78, 1
    01/10/2023, 89, 1
    02/10/2023, 83, 1
    01/11/2023, 73, 1
    02/11/2023, 74, 1
    01/12/2023, 65, 1
    02/12/2023, 64, 1
];