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 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

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!

I am moving data from oracle to SQL server. I am required to move data only for 110 oracle tables out of 500 tables. I habe to keep running this job everyday to capture the deltas as well. I can read a context file which will contain the list of all the tables to read data from oracle and through dynamic schema start doing an upsert into sql server. I.am not sure if this is an efficient way to solution this business ask. Would love to hear from the experts if there is a better way to this. 

Thanks 

Ravi 

Hi!, reading documentation about Qlik Web storage provider 'Google Cloud Storage', it says that you only can put data into a bucket in Qlik SAAS, are there any plans to have this in Qlik Sense Enterprise?

Storing data from your Qlik Sense app in Google Cloud Storage

You can store table data into your Google Cloud Storage bucket in the Data load editor. You can either create a new load script or edit the existing script.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Google-Cloud-storage-provider-connector.htm