Hello everybody!

I'm setting up an integration with Json Web Token (JWT) and I want to create sessions longer than an hour, is this possible?

The payload I am using is the following:

const payload = {
      jti: uid.sync(32),
      sub: `${userName}`, // Usuário obtido do banco de dados
      subType: "user",
      name: `${userName}`,
      email: `${email}`,	
      email_verified: true,
      iat: Math.floor(Date.now() / 1000),
      exp: Math.floor(Date.now() / 1000) + 60 * 60, //Here I want to increase the timeout to more than an hour
      nbf: Math.floor(Date.now() / 1000),
      iss: "myISS",
      aud: "qlik.api/login/jwt-session",
      groups: [
        "Analytics Admin",
        "Data Admin",
        "Data Space Creator",
        "Developer",
        "Managed Space Creator",
        "Shared Space Creator",
        "Tenant Admin",
      ],
    };

Hi, we are in the process of porting a Qlikview app to Qliksense cloud, though we are running into a problem right now. On our qlikview app, we have a document trigger/action which automatically selects possible value(s) for some certain fields, with a few of them being hidden fields(leading underscore fields such as _UserTypeID and _GranteeID). We are unable to emulate this behavior on Qliksense, as the sheet actions will only allow us to choose non-hidden fields. Is this a limitation from Qliksense that we cannot bypass? And if so, what are the workarounds that we can use? Thanks. 

Hello,

I am quite new to Qlik and have no real knowledge yet. So I apologize for what is probably a very simple question for you.

I would like to make an evaluation where I would like to count the number of our invoices using the count function.

The problem is that the same field which is called "Document No." also contains delivery note numbers.

I only want to count the invoices that start with AR....

Which settings should I make?

I hope you can help me

Hi all,

i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.

the token is made up like this:

user details: name sub and email are the exactly like the console.

any idea of what can go wrong here?

thanks,

Loris

Hi all, 

I have this sample dataset from one source.  I want to show in a straight chart, just the Store and Systems columns.  But I want them to be filtered by the dimension Function that has the value of only 'Fixed Ops'.  Any help here would be appreciated, thanks in advance!

Hi, I've been stuck on this all day and its driving me nuts.  I've gone through similar posts but haven't been able to crack it.  Even help from one of my experienced colleagues didn't crack it...

I have calculated the time duration between 2 time stamps.  I now want to categorise this time duration.

The first part of the script works fine:

[vw_ngd_consumer_ee_pn_trdb.test_initiate_time] as "RunTime_Initiate_Time",
[vw_ngd_consumer_ee_pn_trdb.test_completion_time] as "RunTime_Completion_Time",

Time(Timestamp([vw_ngd_consumer_ee_pn_trdb.test_completion_time],'YYYY-MM-DD hh:mm:ss')-timestamp([vw_ngd_consumer_ee_pn_trdb.test_initiate_time],'YYYY-MM-DD hh:mm:ss'),'hh:mm:ss') as "NGD Run Time",

Now here's where my issue is. I want to create a new table that categorises this field.  Alternatively I could add this categorisation as an extra column in the original dataset, but I thought it might be easier to create a new table.  Maybe now?

So the script I've created currently looks like this:

Run_Time_Table:
LOAD
[NGD Run Time],
IF(Time([NGD Run Time]),'hh:mm:ss')<=('00:01:00'),'Less than 1 minute',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:02:00'),'Less than 2 minutes',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:03:00'),'Less than 3 minutes',
IF(Time([NGD Run Time]),'hh:mm:ss')<=Time('00:03:00'),'greater than 3 minutes','Unknown' as "RunTime_Category"


Resident [NGD_Test_Data];

This results in the following error message:

I'm completely stumped as to what the issue is.  I've checked the field names and I can't see any duplicate fields, but obviously I am using [NGD Run Time] field a few times, but that should be fine?

Can anyone spot where I'm going wrong?

I have two fields like 

Order Quantity and Net price Net price in Decimal so I want to include Decimals also. If I use Round Or Floor or Ciel I will miss or Get More Spend.

Output should be like This

Hi, 

I am trying to embed Qlik Sense Sheet into my angular application. I tried different appraoches

1) iframe

2) qlik-embed

but nothing seems to work.

With qlik embed I was able to render qlik-embed task inside my web application but it shows Authorize button when embedded.

I followed steps from this documentation:

https://qlik.dev/embed/qlik-embed/quickstart/qlik-embed-webcomponent-quickstart/


Looking forward for some solution from the community. Thanks in advance. Let me know if you need more details on this.

Hi,

I am trying to get the data from previous month and also that has a specific condition. I am using this formula:

count({<Column.Variable = {'Condition'}>}Column.Variable), count(InMonth(Date.DateAppointment,today(),-1), [Record_ID]))

I can use both conditions separate but cannot find the way them together to get the records for that specific condition for the previous month.

Thanks,