Hi to all

On the next lines a variable that I´m trying to create and insert a variable to get all the tables in a HTML file. 

The value on field "Hojas" is 5 that equals the number of tables in file:  

FROM [lib://Dropbox - alejandro@inflexion.com.co/PruebasHojas/Job REPORTE DE VENTAS, Step 1.htm]

Script:

LOAD
Hojas
FROM [lib://NumeroHojas]
(html, codepage is 28591, embedded labels, table is @1);

let vprueba= Hojas;
drop Table;

For VHojas = 1 to $vprueba;

LOAD
*
FROM [lib://Dropbox - alejandro@inflexion.com.co/PruebasHojas/Job REPORTE DE VENTAS, Step 1.htm]
(html, codepage is 708, embedded labels, table is [$(VHojas)$]);

And I get the next error:

Hi there.

I'm experiencing what seems to be unusual/unexpected behavior using Field Event Triggers in QV.  I'm using QV April 2019 SR1.

My app contains a chart and I change the field of the chart dimension using different buttons.  I use the Field Event Triggers to also be able to have a dynamic drill-down in the chart whereby if a selection is made, the dimension changes to the next level in the hierarchy.  I specifically use the On Select action.  In the app I also have buttons which allow me to change the date range in question at more of a global level, for example, Current Month, QTD and YTD.

The problem that I'm experiencing is that when I change the date range, it seems to trigger the logic in my Field Event Triggers thereby changing the dimension of the chart.  The triggers in my date range buttons don't refer in any way to the fields in my Field Event Triggers and visa versa.

I have been told that because the fields are related, more of an 'implicit' selection takes place but I would have expected that the Field Event Triggers only fire when an 'explicit' selection takes place.  I've also tested the behavior on QV 2017 SR9 and the problem doesn't occur (albeit a more simplified example). 

Please can you tell me if this is expected behavior and if so maybe give me some insight into the mechanics of this.

Regards,

Peter

Dear Experts -

I've read several community posts, but have not found what i need.

I have two node cluster for DC (two nodes) and DR (two nodes) where in qlikview needs to access files from a shared location. This shared location is SAN. what i need to know is the qv files  that are required to be available in SAN so that during DC/DR failover, there should be no issue in accessing qvw and qvd's. 

Also, i hope qv do support SAN and have no latency in accessing or reloading qv files.

Thank you!

SEAN.

Hi everyone,

i have an example data as below,i would like to load the data 

if order by batch no and ODATE, the 1st-row type =C, 2ndrow type =D only load first row data, otherwise, load second-row data order by ODATE

below highlighted in red is the expected output.

is it possible to do this in Qlikview. Thanks!

I have a dataset  with positive and negative values. 

Hi, i would like to calculate consecutive negative or positive value of my table and also maximal.

Is it possible.

Thanks!

Hi,

Is it possible to create dynamic category base on user selections?

In above example,  I have hard coded "Other" category for Products D,E,F

But my requirement is - For example:

If user selects Product A, B then rest of the possible products should come under category "Other"

If user selects A, D, C then rest of the possible products should come under "Other"

Kindly help! 

@sunny_talwar @swuehl   @Gysbert_Wassenaar @tresesco 

Thanks

Hi,

Recently we are forced to change all websites from http to https.

I registered ssl sertificate based on the following instruction:

https://community.qlik.com/t5/QlikView-Documents/Enable-SSL-QlikView-Webserver/ta-p/1495958

 I did all the steps and   as a  last step I run the below command in cmd and I got this message:

The ssl certificate successfully registered,

 netsh http add sslcert ipport=0.0.0.0:443 certhash=0000000000003ed9cd0c315bbb6dc1c08da5e6 appid={00112233-4455-6677-8899-AABBCCDDEEFF}

I changed the port from 80 to 443 and sleceted  "use https"( in qlikview web server), then I reseted qlikview web server.

But nothing happened after that and access point didn’t load with new configuration.

Any help would be highly appreciated.

Hello,

In a interview of Qlikview Admin I have been asked  certain question. The final question was given to me and here are these.

1. Can you or do you know any tool that can automate user access request. We have user access of 300 users daily and we don't want to waste time on manual entering users.

2. How can we automate deployment in Qliksense?  Everyday we are just copy and pasting many application and we want to save time on this 

I need to answer this  by Monday. Any thought?