I'm trying to convert the values stored in the "Change_Mask" column into bit format or Hex values for transformation into bit format, but I can't do it because I don't know the format of the stored values. This is to distinguish between columns updated with 'Null' values and those not updated in the "Change table" used in store changes. While during "change apply," we can differentiate in the "attrep_changes_xxxxx" table, such as 'attu_Null', the "change table" doesn't allow distinguishing whether a column was updated with Null values or if no update occurred. Therefore, I request a method to change the values of "Change_Mask" into bit format (e.g., a value that allows checking the changed column positions like 1100111).

Hi There,

I want to apply similar SQL case statement as below in the QVD while loading the data. Please guide me. Thanks.

CASE
WHEN RAISED_DATE < TO_DATE('30-06-2016', 'DD-MM-YYYY') THEN TO_DATE('01-07-2016', 'DD-MM-YYYY')
ELSE RAISED_DATE

END AS RAISED_DATE_MIN

Dear.

This issue happened at the Qlik Sense Nov 2023 version in my case.

Step 1: In Qlik Sense Hub, I'm creating Data connection. 

Step 2: Click on Office 365 Sharepoint. 

Step 3: Then I'm giving the our Share point URL. 

Step 4: Below I tried to choose all the below options. Then i will click on Authenticate. 

Error Message *******

Office 365 sharepoint Authenticate button is working well at the Sense Feb 2024 version.

What could be the problem?

Hi,

I want to add reference line on my x- axis.
my x-axis is my ItemID.
my Y axis is cumulative margin.

I tried to crate whale chart and I want to know where is the spot when my whale chart start  to descending with the reference line.

this is my line chart so far:

I tried to add the reference line with this expression:

Aggr(If(Rangesum(above(total ROUND(sum(margin)),0,RowNo())) = Max(total Rangesum(above(total ROUND(sum(margin)),0,RowNo()))), ItemID), ItemID)

but I don't see any line on my X-axis..

Can someone help me please? 

Hi Team,

I am trying to connect to Snowflake and insert/Retrieve data from it for the connection purpose I use SnowFlake in MetaData section I have given all the details correctly and the connection is successful , when I click on Finish it shows Save Failed! error with below details

When I try with Snowflake Input component the connection gets successful but when I run Nothing happens

I use Talend 8.0.1

Snowflake JDBC Version 3.13

Save failed!

 org.eclipse.core.runtime.CoreException: Error when saving the connection

   at org.talend.repository.generic.ui.GenericConnWizard$1.run(GenericConnWizard.java:311)

   at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)

   at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2338)

   at org.talend.repository.generic.ui.GenericConnWizard.createOrUpdateConnectionItem(GenericConnWizard.java:319)

   at org.talend.repository.generic.ui.GenericConnWizard.performFinish(GenericConnWizard.java:259)

   at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:832)

   at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:472)

   at org.eclipse.jface.dialogs.Dialog.lambda$0(Dialog.java:619)

   at org.eclipse.swt.events.SelectionListener$1.widgetSelected(SelectionListener.java:84)

   at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)

   at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)

   at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4209)

   at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043)

   at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4026)

   at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3626)

   at org.eclipse.jface.window.Window.runEventLoop(Window.java:823)

   at org.eclipse.jface.window.Window.open(Window.java:799)

   at org.talend.repository.generic.action.GenericAction.doRun(GenericAction.java:71)

   at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:678)

   at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:103)

   at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:259)

   at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:3767)

   at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:2679)

   at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:688)

   at org.eclipse.jface.action.Action.runWithEvent(Action.java:474)

   at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:580)

   at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:414)

   at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)

   at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4209)

   at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043)

   at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4026)

   at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3626)

   at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1157)

   at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

   at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)

   at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)

   at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:644)

   at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

   at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:551)

   at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:156)

   at org.talend.rcp.intro.Application.start(Application.java:303)

   at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)

   at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

   at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

   at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)

   at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)

   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)

   at java.base/java.lang.reflect.Method.invoke(Method.java:578)

   at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:654)

   at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

   at org.eclipse.equinox.launcher.Main.run(Main.java:1462)

 Caused by: org.talend.daikon.exception.TalendRuntimeException: FAILED_INVOKE_METHOD:{class=org.talend.components.snowflake.SnowflakeTableListProperties, method=afterFormFinishMain}

I tried with JDK 19/JDK 1.8/JDK 11 still I get the above error, please help

Hi All,

I am working on vizlib library replacements in QS
i have to add one inbuilt Filter pane in place of vizlib filter pane

In that Vizlib filterpane , Dimension added in CLeveleSelect
and Filter values condition given as     =IF(ONLY({1} CNLevelOrder)<14,True(),False())

So in VizLib Filterpane LevelSelect values are shown based on above condition,

how to show the same in in bulit Qlik filter pane

Please reply back 
Thanks

Hi,

I've been using it very well since the Window function was added.
I wonder if the window function or the group by consumes more resources.
And what functions perform faster when loading data?
I don't know the difference because my test data capacity is small.

Reply, Thanks!