Welcome to Qlik Community

Currently we have been using compose to transfer the data from storage layer to provision layer(HDFS in parquet format)

By default it is using the below command for writing the file to HDFS.

<D_F>.write
.mode("Overwrite")
.format("PARQUET")
.save("hdfs:///....")

We need to include partition/bucket parameter based on some column to write the parquet files in HDFS based on partition/bucket key.

Kindly advise if there any way to do.

Hi everyone, 

I stored a Field in QVD Table , and when I try to read it in my Report i see that the Values are align sometimes right and sometimes left.
i think that Qlikview considers some Values as number and some of them as String !!

How can i fix this Issue ? I try to multiplie the Field with other Field and i get false Results . should i convert the Field to number or how can I fix this Problem ? 

OLEDB Connection string missing out values when ODBC works fine with the same extract file.

I have a simple extract file with 1 query:

QUALIFY *;

MyQVTable:
LOAD *;

SELECT * FROM MyTable;

STORE MyQVTable INTO $(vQVDDirectory)\MyQVTable.qvd;

DROP table MyQVTable;

If I use the OLEDB connection string:

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=USERNAME;Data Source=SERVER;Extended Properties=""] (XPassword is PASSWORD);

It doesn’t return ALL my data but it does if I use ODBC

ODBC CONNECT TO [SERVER;DBQ=SERVER] (XUserId is USERNAME, XPassword is PASSWORD);

Hi,

I have a need to calculate the last 6 months (excluding the reported month) Sales for a given reported date in the sample provided.

For instance, Customer 20170 will have the following details once completed in the data model.

11/2017 - $343,913

10/2017 - $343,562

I have tried the concept with a IF...previous and RangeSum with Peek but I cannot do something similar to Above function in Script.

Appreciate your assistance.

Hola a todos! soy nueva en Qlik sense y estoy tratando de sacar el porcentaje de aprobación, rechazos etc.. Tengo lo siguiente:

Para TOTAL APROBADAS arme la medida maestra:

COUNT ({<EstadoAutomatico={"TRMITP","TRMITR","TRMITA"},Progress ={"40"},LoanProduct = {"Prendarios"},
[Opportunity.TransDate.autoCalendar.YearsAgo] = {0}>} EstadoAutomatico)  

Para el porcentaje de aprobadas estoy usando lo siguiente y no me funciona:

Sum ({<EstadoAutomatico={"TRMITP","TRMITR","TRMITA"},Progress ={"40"}, LoanProduct = {"Prendarios"},
[Opportunity.TransDate.autoCalendar.YearsAgo] = {0}>} EstadoAutomatico)

/ Sum ({<EstadoAutomatico= {"TRMITP","TRMITR","TRMITA"},LoanProduct = {"Prendarios"},
[Opportunity.TransDate.autoCalendar.YearsAgo]= {0}>} TOTAL EstadoAutomatico)

Ojala me puedan ayudar.

Gracias de Antemano.

Hello Everyone,

Below is my sample data and expected output is if i select  last 2 days, in the bar graph , it should show Load values as 86915,88665 in the Y -axis. I know how to get last 2 days, but couldnt able to get cumulative sum if i use 

RangeSum(Above(Sum(Records), 0, RowNo()))

as it shows 1710, 3460 for the last 2 days.

Please provide the solution if possible

Thanks

Chris

Hi,

I'm trying to configure Qlik-cli in our server .

I connect successfully to it but then when executing commands like start-qliktask I'm getting bad request (400) error.

Other api calls like getAbout or so are working correctly.

I followed the steps to install the certificates from GitHub page and qlik help.

Any clues?

Thanks