I have a data source (1M Rows) with many (approx 50) dates (DD/MM/YYYY) in each row and i only need to retain rows where at least one date per row is > 30/10/2019,

Some date fields are null

So any rows that have no dates above 30/10/2019 are not needed

Here's some example data to work with...

So in the example above only ID 1 & 4 would be needed

I'm making a custom connector. I based it on 'QvEventLogConnectorSimple' from the SDK v2.1 examples. It seems to work, I also added a 'standalone' form. It is still very basic.

Now I placed it (and the sample) in 'C:\Users\USER\AppData\Local\Programs\Qlik\Sense\Connectors' and in 'C:\Users\USER\AppData\Local\Programs\Qlik\Custom Data' but it still won't appear. I do have a web folder.

EDIT:

I do see the connector now in the log 'ConnectorRegisterProxy'. I figured out that the 'verpatch' wasn't working, I downloaded a newer version. I have a web directory, but maybe that is the problem, I trying to see if the content is correct

EDIT 2:

Okay, I have it visible if I click on 'Script Editor' followed by create connection. It just isn't visible under 'add data from files and datasources'

Hello,

I have just finished a app that holds a table only. When I export the table to excel I am either getting a blank file with headings only or if I filter and bring in only a small number of rows (less than 10), then I get excel to download as expected.

What could be going wrong?

Thanks

Hi,

I am in the process of Installing the Qlikview Server ( Installing the latest version April 2019 SR1), should I be doing the install of Full Installation, Single machine with Qlikview Webserver

Or tick the ones from Profiles which gives me the following list of the ones to choose to do the installation for

Qlikview Server

Reload/Distribution Engine

Management Console

Webserver

I am unsure though about the Webserver? How do I know if my current server is using this ( current server is on version 11 sr2) and should I just do the Full Installation?

Thanks

HI techies,

I am using Qlik Web connector licensed for Mongo DB. I have created a connection with a collection and fetch 4 columns. one column under sub doc has data in array or json format. Json format value is not constant in length or size it could be null or blank as [] also. Look at the below two records, first one has two parts Rohit and Kumar and second record has only Tony.

[{ "name" : "4050 Rohit", "id" : 881 }, { "name" : "4053 Kumar", "id" : 883 }]

[{ "name" : "4050 Tony", "id" : 881 }]

Now I need to convert the array or json data into two columns first will be name and second will be id.

Is there anything I need to set in Qlik Web mongo DB connector from https://docs.mongodb.com/manual/reference/operator/query/ so json data in field will be parsed before loading into Qlik ?

Can you please guide me how to do it ?

Thanks in advance

Rohit

Hello everybody,

we have a problem which my collegues and i are struggling to solve - we got this project for the univercity as a graduation project,  we should develop a data structure and apps in qlik sense for a company in supply chain management. we managed a little structure, where to collect the data from customers and how to calculate, but unfortunately have no experience in qlik sense or in supply chain management. so we have been searching for answers for a while now and i thought i would try my chances here.  any help is immensely appreciated.

the topic is the following:

With the help of "QlikSense" an interactive overview and a related detail view of the following subareas of the end-to-end supply chain shall be created:

· KPI (Key Performance Indicator) Management Cockpit "

o Visualization of the most important key figures of the company (otif, forecast accuracy, forecast bias, stocks, inventory range, delivery rythms, wip - work in progress etc.)

o SLA (Service Level Agreement)

· Lead time

o Delivery time

o Production time

o Replacement time

· Stocks

o finished products

o WIP (Work In Progress, semi-finished products)

o raw materials

Any ideas how to begin with this ?

Thank you all in advance!

We have recently installed Qlikview and trying to bring up our Dashboard. 

The installation and lisence application is successful. 

When we are accessing the access point URL, it fails to show any dashboard deployed and returns an error message as "No Server". 

Upon checking all Qlikview services are running and healthy. 

The Event log file has the below error : 

"Error System: CQvXmlInterfaceRequestHandler - Catch: errId(-3). Ino(-1). Fno(91)"

Can someone please help.