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. 

Hi,  is there any way for force the user to download and install the IE plugin when the user goes to the Access Point.  We are dealing with an environment where the users can be using either IE or Chrome.  Some users have the plug in installed others may not.  We would like to have a consistent user experience. 

Hi, 

I have a field that contains multiple key values I'd like to split into multiple fields within the same table. The challenge is that I need to do that for multiple tables, and the number of key values to split in each of those tables is different. 

Example data:

table1:

LOAD * INLINE [

key, kpi_name, kpi_value

1|2|3, sales, 1000

4|5|9, sales, 500

10|9|4, profit, 300

1|3|6, profit, 200

];

table2:

LOAD*INLINE[

key, kpi_name, kpi_value

1|4|5|6, visitors, 500

9|0|9|7, visitors, 4000

9|8|8|7, shoppers, 400

];

Desired outcome: 

table1:

key1, key2, key3, kpi_name, kpi_value

1,2,3, sales, 1000

4,5,9, sales, 500

10,9,4, profit, 300

1,3,6, profit, 200

table2:

key1, key2, key3, key4, kpi_name, kpi_value

1,4,5,6, visitors, 500

9,0,9,7, visitors, 4000

9,8,8,7, shoppers, 400

];

A similar problem has been addressed here but it splits the field into multiple tables connected by synthetic keys rather than multiple fields within the same table:

https://community.qlik.com/t5/QlikView-Scripting/Splitting-a-field-into-multiple-fields/td-p/400842

Is there a way to split the key field into multiple fields when the number of values to split is variable?

Thanks for your help,

Laura 

Hi All,

I have to create a filter as (reading_materia)l with four columns A, B, C and D and I have to do this only on sheet.

How can I do this ?

if(A = 0,'Book',
if(A= 1,'Pen' ,
if(B= 1,'Eraser' ,
if(C= 1,'cutter' ,
If(D =1,'pencil'
))))) as reading_material

Thanks In Advance

Hello guys..

I am trying weeks but I didn´t get data.

I can connect but get only 10 raws.. I know that WooCommerce APIs send 10 raws per page.

Anyone can help me?

Documentation page of WooCommerce is in http://woocommerce.github.io/woocommerce-rest-api-docs/v3.html?shell#pagination

Thanks so much

Tomas

I am able to retrieve the sheets list in an app using the call below.

 /iv/qrs/app/object/?Xrfkey=<xrf-key>&filter=app.id eq <app id> and objectType eq 'sheet'

The problem is that this retrieves the sheets in random order and there is no way to tell what order these sheets appear on the sheets list when accessed via HUB UI. Is there any way I could force the engine API return the sheets in the same order as they are on the HUB UI. Or some other kind of parameter I could use to determine this?

Hi All,

I have a requirement like to present all risks below 4 score should appear with green color and all to gather in the same place(Not count of risks) means all those should appear 0-4 score rage of X-axis and 5-10 score risks in between 5-10 score and amber color, 10-27 above score red color