Hi all,

I would like to create an expression in Qliksense that shows value as % of row total TEU, based on the Quote Type.

Is there a way to do that in Qliksense?

Hello,

 if  particular task always fails i generally rerun it manually before business could see data.  Business will see the data by 7 PM and this task fails before that.  I want some automation scripts so that if the task fails it will run automatically.  Please suggest.

Niha

i have been asked in an interview if I have any ideas how to automate deployment. Daily they have many qvf and they are just wasting time only by copy and pasting to different environment. Any way to automate this?

Niha

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:

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?

Hello all,

I searched and tried to apply many posts here and elsewhere but could not find the solution. Please keep in mind I'm at the very beginning of using QlikView. 

I joined two files into one Table box but when I tried to change the blanks into "n/a" it didn't work. Don't have idea what to try next.

My script is:

LOAD CODE as ID,
Name as Name_1

FROM
[Path.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

join

LOAD CODE as ID,
LastName as LastName_1

FROM
[path.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

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!