The trend line must display for the years 2021, 2022, 2023, and 2024 under the given conditions, regardless of the year selected in the filter pane.

Aggr(
RangeSum(
Above(
sum(
{$<
[Product Group]={'CV Azurion 3', 'CV Azurion 5', 'CV Azurion 7 Biplane', 'CV Azurion 7 Monoplane', 'iXR CV FD based system', 'iXR CV II based system'},
[Material Description]={'APM CHOICE MRC200 0407','APM CHOICE MRC200 0508','MRC 200 0310 ROT-GS 1004','MRC 200 0407 ROT-GS 1004','MRC 200 0407 ROT-GS 1004 PREOWNED','MRC 200 0407 ROT-GS 1004 X-Ray Tube assy','MRC 200 0508 ROT 1003','MRC 200 0508 ROT-GS 1001','MRC 200 0508 ROT-GS 1003','MRC 200 0508 ROT-GS 1003 PREOWNED','MRC 200 0508 ROT-GS 1003 X-Ray Tube assy','MRC 200 0508 ROT-GS 1003-OBSOLETE','MRC 200 0508 ROT-GS 1005','MRC 200 0508 ROT-GS 1005 X-Ray Tube assy','MRC 200+ 0407 ROT-GS 1004','MRC 200+ 0407 ROT-GS 1008','MRC 200+ 0508 ROT-GS 1003'},
[Part Type]={'Tubes'},
>} Quantity_Consumed
),
0,
RowNo(total)
)
),
Year,Month
)

Hi,

I have the following table:

As you can see, there are travels made in the morning, and others made in the afternoon, What I need is to group those travels made one after another with a difference in time no longer than 30 minutes to consider them as one long travel from A to D. At the end there would be to long travels one made in the morning and other made in the adternoon, both from A to D.

Is important to note that if the individual travel that was done with a difference loger than 30 minutes can not be considered as part of a group of travels but as an individual one.

Thanks in advance

Dear all,

I'm getting some errors during API call from an other server to the Qlik Sense Server.

I'm not able to use the SSL Port only the 4242 port . why ?

url : https://myserver.com:4242/qrs/about

{
"buildVersion": "31.39.2.0",
"buildDate": "3/12/2024 08:13:57 AM",
"databaseProvider": "Devart.Data.PostgreSql",
"nodeType": 1,
"sharedPersistence": true,
"requiresBootstrap": false,
"singleNodeOnly": false,
"schemaPath": "About"
}

url : https://myserver.com:443/qrs/about

< HTTP/1.1 401 Unauthorized
< Content-Length: 0
< Server: Microsoft-HTTPAPI/2.0
< WWW-Authenticate: Negotiate
< Date: Wed, 25 Sep 2024 12:50:45 GMT

https://myserver.delvaux.com/qrs/about

< HTTP/1.1 401 Unauthorized
< Content-Length: 0
< Server: Microsoft-HTTPAPI/2.0
< WWW-Authenticate: Negotiate
< Date: Wed, 25 Sep 2024 12:51:59 GMT

the auth. method is by certificate, if this can help.

thanks in advance for your help

Benoît

Hi Team,

I need to configure the Postgres DB SSL certificate in Talend for establishing a secure connection with DB from Talend. But the error was occured.

Can you check what wrong with my setting?
Basic Settings:

Advanced Settings:
"ssl=true&sslmode=verify-ca&sslcert=C:/xxx/postgresql.crt&sslkey=C:/xxx/postgresql.key&sslrootcert=C:/xxx/production_root.crt"

My key worked well with Dbeaver!

If you need more information, please comment!

Thanks in advance.

Regards,

Hi  All,

ı have straight table dimension like this

=if(statü like 'Ok' or ([statü like 'NoOk' and [Quality]>0),Type)

I want to dimension calculatıon add in set expression.

My set expression:

sum(
{<
[CompanyCode]={"1300"}, 
[MaterıalCode]={"A300"}, 
[TypeMaterıal]={"1","2","3"}
>-<
[Flag]={"X"},
[Group] ={"*Gal.Fas.Boy.Rlo"}
>}Sales)

Thank you so much

Hi,

Has anyone managed to get the high-throughput API working in a connection to BigQuery in Qlik Cloud?

If so, what was the improvement in data extract performance?

And more importantly - how did you do it? We've been trying to get this working now for a while, but we're coming up short in terms of success ..

Hello,

I have been tasked with creating a dashboard that allows users to toggle between two different unique IDs, using them as the primary key. By default, the dashboard loads with `ID_1`, but users should be able to switch to `ID_2` through a variable toggle.

My question is: how can I configure this variable and apply it in the visualizations? Should I use something like a `vPrimaryKey` variable as a measure, or is there a better approach to handle this requirement?

I would appreciate any guidance or alternative solutions. Thank you!