Hello,

we are using a binary load for one of our QlikView analyses.
The following expression works in the base analysis, but not in the binary-loaded analysis:

=sum({<
AuftragsMonatZahl -=,
/*DispoLieferMonatZahl= {'>=1<$(=num(month(today())))'},*/
AuftragsMonat -=,
DispoLieferJahr = {'$(=year(today()))'},
Auftragsart = {'Auftragsbestand'},
AuftragsJahr -=,
AuftragsJahrMonat -=,
DispoLieferMonat -=,
DispoLieferdatumJahrMonat -=
>} AuftragWarenwertNettoOffen)

I've identified that the main issue is related to the field 'DispoLieferMonatZahl'.
As soon as I comment out this part of the formula — as shown above — the expression returns a value. Otherwise, the result is always 0.

The values in DispoLieferMonatZahl appear as 1,2,3,4 etc., just like in the original analysis where the formula works correctly.
So I believe the format is correct?

Do you have any ideas or suggestions for resolving this?

Thank you very much!

Regina

Hello team,

We are trying to create a task in which one table is present and from that table we are trying to extract 1 result through expression builder.

We tested the SQL syntax as our source DB is Oracle and it's successfully passing the test expression but still instead of getting Transferred count as 1, it's giving the count as 31,362,906.

Don't know whether we are using the correct syntax or not but not getting the desired result.

We are feeding the syntax Table Settings>>Filter>>Expression Builder.

Could you please assist on this ?

Hello,

I am trying to pull data from Darwinbox tool using Api integration,

If anyone has accomplished this, could you please provide me the steps to integrate this?

thanks,

Adithya

Hi,

We are using the Qlik Enterprise Edition, May 2024 version, and currently employ Capability APIs to integrate visualizations into our React application. We are now transitioning to the @qlik/embed-react library.

Our authentication model utilizes tickets, configured in the Qlik Management Console (QMC). However, when connecting with @qlik/embed-react, we encounter an "internal_window_authentication" issue, resulting in a 401 error. How can we resolve this issue?

Below is the current code we are using:

I'm using two alternate states (Left and Right) to compare two periods. In my expression I want to derive the number of new customers where the previous period is in alternate state Left. The latest period is in alternate state Right. I try to ignore a selection on [Department] in the deault state.

However the outcome of the calculation differs when I make a selection on Department in the default state.

What is wrong with my expression?

Count({Right*$<
%Relation_key = e({Left*$}%Relation_key),
[Department]=
>}
DISTINCT %Polis_key)

Qlik Sense Enterprise on Windows 

Hello i need some help integrating qlik into my react application.

I am using @qlik/react-embeed and everything is working fine but i have issues figuring out how to provide initialSelections in react-embeed.

For example:
I have a sheet with some chart and on my react-application when user clicks on a table row, i want to show him chart for that specific user, meaning i have to provide an initialSelection to my qlik sheet.

Now in the documentation i see it exists, but the example is in web-components, not react-embeed and i dont know how to integrate it in react

<qlik-initial-selections app-id="a51a902d-76a9-4c53-85d2-066b44240146">

<field state="comparison" name="Product Sub Group Desc" values="Hot Dogs;Fresh Fruit"></field>

<field state="comparison" name="AccountDesc" values="Sales;Cost of goods sold"></field>
</qlik-initial-selections>

 
Here is my current integration code:

import React from 'react';
import { QlikEmbed as QlikEmbedAnalytics, QlikEmbedConfig, HostConfig } from '@qlik/embed-react';

interface QlikEmbedProps {
  appId: string;
  sheetId: string;
}

const hostConfig: HostConfig = {
  authType: 'Oauth2',
  clientId: '<client-id>',
  // clientSecret,
  accessTokenStorage: 'session',
  redirectUri: 'http://localhost:3000/oauth-callback.html',
  // apiKey: import.meta.env.VITE_QLIK_API_KEY,
  host: import.meta.env.VITE_QLIK_HOST,
};

const QlikEmbed: React.FC<QlikEmbedProps> = ({ appId, sheetId }) => {
  return (
    <QlikEmbedConfig.Provider value={hostConfig}>
      <QlikEmbedAnalytics
        ui="analytics/sheet"
        context={{
          interactions: { active: true, select: true, edit: false, passive: false },
        }}
        appId={appId}
        sheetId={sheetId}
        theme="WunderMobilityTheme"
      />
    </QlikEmbedConfig.Provider>
  );
};

export default QlikEmbed;

I have used @qlik/embed-react to embed qlik cloud in reactjs and i want to get current selection in my reactJS app. 
i am embedding selection bar using below code 

 

  const hostConfig = useContext(QlikEmbedConfig);

  const app = useApp(appId, hostConfig);

 

and also have a hook useApp :

export const useApp = (appId, hostConfig) => {

  const [app, setApp] = useState(null);

  useEffect(() => {

    const getApp = async () => {

      const session = qix.openAppSession({ appId, hostConfig });

      const doc = await session.getDoc();

      setApp(doc);

    };

    if (hostConfig) {

     return app;

    }

  }, [appId, hostConfig]);

  return app;

};

can anyone please help me how i get selection/filters values for current sheet

Please help me here.

Hi devs,

Is there a way to enable the native chart styling option/panel in an extension?

I can set the object background using
element.closest('.qv-inner-object').css('background-color', 'transparent');
here set to transparent, but can be any color either hard-coded or set via color-picker in a custom accordion item, but would be good if we could access the native styling panel? Is it possible?

Cheers!

Hi all,

I saw that in the latest version of QS (May 2025), JSON loading is now supported natively. Do we have any demo or example showing how this works?

Thank you.