QlikView

Hi Friends!

As per the attached data set, if I need to specify a special record with its reference number quoted from a given dimension, what formula to be used. For eg, If I only need to show the claim number as against the paid amount of Rs 20638/=, how it could be done while not showing claim numbers for all other records.Because if I add the claim number dimension, numbers for all the amount paid will be appeared.I need it only for the above record to be appeared

Also, if I'am to do kind of a data validation like circling the said record, how the steps to be followed looks like ?

Look forward  for your kind  response!

Thanks

Neville

Hi all,

I started to develop an extension for graph visualization based on the Graph Dracula Library, using Raphael: http://www.graphdracula.net

This seems to be an interesting topic. First of all, what is the best data representation of graph data in a relational QlikView world? Second, there are a lot of limitations using those JavaScript libs. I've tried some before (D3.js etc.) but Dracula seems to have the simplest interface for my use case.

What is your opinion?

- Ralf

Hi everyone,

I have a question about missing values in pivot table. 

I have created this pivot table to follow different biometrics each day :

I have colored each missing values with yellow but it's not what I wanted to do.

I have to color the missing values if they are missing for 3 days or more.

My question is if it's possible to do that with a function in Background Color ? Or as they are missing values, I will have to work in the script (by turning them into numeric values or an other trick) ?

Thanks for your help, 

Alice.

Hi

I have a table with tasks and subtasks

task1     subtask1     subtask1_status
task1     subtask2     subtask2_status

task2     subtask1     subtask1_status
task2     subtask2     subtask2_status

task2     subtask3     subtask1_status
task3    subtask1     subtask1_status

task3    subtask2     subtask2_status

I would like to populate a new field task_status that will say 'done' if all the subtask_status are done or 'In progress' if even one subtask is in progress. I am guessing this will need to be done using set analysis, but how would i go about it?
also need to know how this would work if tasks and subtasks are in different tables (joined by a task_number)

thanks

Dear all

I have a table in a server and another one in another server i want to join these two when i write the query in sql server every thing is ok but in qlick script i get error:

Table1_label:

[connection to server1]

sql

Select * from Table1

Table2_label:

[connection to server2]

sql

Select * from Table2 inne join Table1_label

please let me know how can i do this

thanks in advance

I have a pivot table like the one below. I am graphing this as a bar chart where N, Y are the x-axis, % is the y-axis and each A% and B% pair are the bars. Is there a way to sort this on the x-axis based on the A% value. For instance, here YA% is 0 whereas NA% is 3. YA% would be to the left of NA% on the x-axis on the bar chart. The NB% and YB% values do not matter in this sort.

Hi All,

If I create OBDC in my local using my personal ID and if the QVW file moves to server where ODBC is configured using System ID, would my file work?

Or I need to create ODBC connection using System ID in my local also.

Thanks,

Sarif

Reload Time not being updated when QVW run on QMC :

To display the latest time i have to run the file manaully .  and i am using ReloadTime() function . 

It should get updated if the application is run throught the QMC task. 

Thanks,

After a recent upgrade to April 2019 SR3 we received reports of users receiving the "Export failed please check server log for more details (It's most likely that export process took too much server resources)" message. We successfully tested exports, so this was surprise. We were looking at KB46660 to increase the export limits but found that was not the issue. The issue was corrected by recreating the specific charts in the new version of Qlik. Hope this helps someone.

Symptoms:

• Export fails for some objects works for others.
• If a chart is throwing this error, it will always give the error regardless of the amount of data (even one row) is selected.
• Error to end user is received immediately, not after the default 3 minute timeout
• Could reproduce issue in QV Desktop – Excel document created with no data
• QVS logs showed a slightly different error than shown in the support documents. It was identical except was “XlsxExport: Exception(3) is caught…”
• Recreating the chart from scratch in the new version of QV Desktop resolves the error

This is my first time declaring a variable in SQL.   When I run the QVD that references the SQL code I receive the following error:

ErrorSource: Microsoft OLE DB Driver for SQL Server, ErrorMsg: Incorrect syntax near 'SMALLINT'.

TimePeriod:
noconcatenate
SQL Declare SMALLINT

Declare $(@CYFiscalPeriod) SMALLINT;
SET @CYFiscalPeriod = (
SELECT
max(FiscalMonthNumber)
FROM [D].[m].[DimTimePeriod] Where Month(GetDate()) = CalendarMonthNumber
);

Hello all,

I'm trying to load a local JSON file in qlikview. I have already managed to load specific 'tables'  from a JSON file by using the following code:

Test1:
LOAD * FROM [.\test7.json] (json, Table is [./TEST1], codepage is 1252, embedded labels);

Test2:
LOAD * FROM [.\test7.json] (json, Table is [./TEST2], codepage is 1252, embedded labels);

But I also want to load data from 'details'  table, which is a level lower then ' TEST1'  (see attached zip file with json and qvw). I would expect that  I would be able to get this data by using something like: Table is [./TEST1/details], but that doesn't seem to work.

I really need your expertise. Who can help me solve this problem?

Greetings,
Eelco