We have a QV application which have problems with tiemout during calculation/selection when running the application using QVS/QWS and web client. We have an interface where the user can select which fields to display including calculated aggregated columns and the columns are displayed in a table object. This slection would result in one row being displayed in the table box (using probably 5000 rows in the underlying table for the aggregated column). When the user selects the calculated column it take a very long time and get calculation error after about 2 min (probably IE timeout). 

I took the qvw file and loaded in Qlikview desktop and same selection/calculation finish in 5 seconds. 

The qvw file is 1.8 GB, 202 mill rows and is about 6 GB loaded. 

I notice we get the same problem in our test environment. Not the same data and smaller (1.1 GB). Our test QVS/QWS server has 32 GB memory. When executing the calculation I notice how memory usage increase from about 5 GB for QVS up to take all availab le memory (and not ever finishing before timeout).

When using QV desktop memory usage is about 6GB all the time (more of course when displaying more data in UI).

What can cause this? I understand that running through QVS/QVWS and web client is slower but not like this. Also the application worked fine some time ago with same amount of data. 

Show Less

Hi All,

I've a country eg ABC, it's data is missing in source DB for weeks 12, 13, 14, 17 and 50.

As I already have a master calendar, so I can see missing weeks as grayed out (Excluded) in list box.

Is there any way I can show data as 0 for those missing weeks in a line chart.

List of dimension and measures used in line chart.

Dimension - Week

Measure - Count(app_Id)

 

 

Regards,

Sumit

 

 

 

Show Less

Greetings!

We are following the instructions provided by Qlik's documentation to change the ciphers used in port 9200 (Qlik License Service).  We changed to section on [license.parameters]  in service.conf as shown below, but now the port does not come up

[licenses.parameters]
-qsefw-mode
-cipher-suites=TLS_RSA_WITH_AES_256_GCM_SHA384,TLS_RSA_WITH_AES_128_GCM_SHA256
-app-settings="..\Licenses\appsettings.json"

We are running a single node instance of QSE June 2020 Patch 3 (13.82.11) on Windows Server 2012 R2 Standard.

Has anyone had a similar problem?  If so, how did you solve it?

Please advise.

Cheers,

++José

Show Less

Hello, I have and issue with the Jira web connector and Jira label: when in a given Jira issue I have several different labels, the connector only returns one (see screenshot). Anybody experience the same issue? Thanks in advance, Show Less

Hello,

I want to represent the last 6 days of data as a boxplot but I'm having dificulties.

I don't know exactly where should I enter the expression.

So I have as Box field City,  as X-AXIS the Date and on the measure the averge of sales(avg sales).

Normally if no data/interval of data is selected I would show the last 6 days. If I put on the X-AXIS the expresion my boxplot breaks and I get "the chart is not displayed because it contains only undefined values"

Expression the X-AXIS  for the last 6 days

=IF(GetSelectedCount(DateAll)>0, Date(DateAll,'DD-MMM'),
if(DateAll<='$(=YESTERDAY)' and DateAll>='$(=YESTERDAY-6)',Date(DateAll,'DD-MMM')))

What am I missing here? AmI suppose to use an agg on the avg(sales) ?

Show Less

Dear Community,

Your help is appreciated for the below question. Thanks in advance!!

AS shown below one MSL has Created Dates in months of june,july,december. Now i have to generate records so that each ME will have created dates > then the existing dates and less than the Max(created date) for this MSL also each ME will have Created Date month in the list of months MSL has got. and Response Score should be of latest month avaiable for that ME.

MSL ID	ME ID	Created Date	Response Score
1	101	july	5
1	102	june	4
1	102	july	5
1	103	december	2
1	104	june	3

So in this case records generated must be as below:

Explanation: MSL Months= June, July, December. Now ME ID 101: He has record of July, so the next month in MSL list is December so in below table you see december record created.

For ME ID 102: already June, july are existing and nxt mnth in msl list is December, so this record is created in below table.

For ME ID 103: December is the latest mnth for this me and this month is the last month in MSL List. So we need not do anything for this record.

For ME ID 104: THis ME has record in june. Nxt months in the list of MSL are july and december ; so these two records are created as below.

MSL ID	ME ID	Created Date	Response Score
1	101	december	5
1	102	december	5
1	104	july	3
1	104	december	3

And this has to be reated for more than one MSL.

Show Less

Hi Community members/Qlik Community Site Manager,

I have published a QlikView document in Qlik community under

Qlik Community --> Data Analytics Forums --> QlikView --> QlikView Documents.

The document is visible only under my login. It is not visible for community members. I don't know the reason.

I need your help to make my document visible again to community members.

Thanks

Pradeep

Show Less