Hi, QLik support,

Best regards, I am SAP Basis Netweaver consultant, we are currently in a SAP project and we need to modify the Text Lang flag field of the SPRAS data element in the / QTQVC / LANGUAGES structure, but the error indicated is "Namespace / QTQVC / does not exist".

Please indicate the way to solve the problem or create the namespace, we only find information about the applied transport order QT2K900068 but still it does not allow to modify the structure.

Your help please,I attach images.

G'day,

It is normal for the new Trial Unlock file for Qlik Sense Desktop to come out before or after it expires? Needing to refresh my memory on dashboard creation for the upcoming Qlik Connect conference in Orlando so I can get certified. Thank you!

Hello,

We have a Full load + Store changes task which loads data from Oracle to ADLS(parquet snappy format). But it is failing for one table during Full load with the error:

Tengo un problema con "Text Object" de QlikView, se ingresa la ruta de una imagen, la imagen esta en un servidor externo, simplemente la imagen no aparece, la ruta se ingresa  de la siguiente manera: ='http://dominio/Carpeta/'&%imagen&'.jpg.

Para verificar  en acciones (open url) se ha dejalo la misma ruta y si se logra visualizar la imagen ya sea en una ventana nueva o en la misma pero no dentro del "Text Object".

Si alguien ha tenido este problema que me pudiera orientar.

gracias

Hi, 

I'm working on a load script for a new app and want to validate that I don't have duplicate Item numbers before loading. If there are duplicates, I want to stop loading.  My code is not working, but I'm not sure why. If I look at the variables in a sheet, there is a value, but not when I try to print them using Trace, even when it's outside of the IF statement. . 

Values:

LOAD

   ItemNumber

   Date,

    Price

FROM [*QVD File*]

WHERE

year(Date) >= year(AddYears(Today(),-1));

Right keep(Values)

LOAD

    NAME as ItemNumber,

    Target

Description

Color

Size

Status

FROM [*Excel File*]

Let vDistinctNumberCount = Count(distinct TAGNAME);
Let vNumberCount = Count(TAGNAME);

If $(vNumberCount) <> $(vDistinctNumberCount) then

    TRACE "*******Error Total ItemNumber count > Distinct ItemNumber count";

End If;

Hello everyone.

How do I extract a string content from a column into multiple columns?

I have this:

And I want to turn it into this:

Mind you, the original column "TEAMS" may have a different number of values. So the Job has to be dynamic to create as many columns as the values in the original "TEAMS" column.
The "-" character is the values separator.

I just can't seem to get over this hurdle.
Can anyone please help me?

Thank you so much,

Rui

Hi,
We ran into aggregation issues with "Keep" statement. When I change Keep to Join, the aggregation works as expected. Here is the script and what's expected.
 
X:
LOAD * Inline[
TICKET_NBR, TRAN_DATE_KEY, TRAN_NBR, TRAN_KEY
A1, 10, 1, 1000
A1, 10, 2, 1000
A1, 11, 3, 1001
A2, 10, 1, 1000
A2, 10, 2, 1001
A3, 10, 1, 1000
A3, 10, 2, 1001
A3, 11, 3, 1000
];
Left Keep (X)
Y:
LOAD * Inline[
TRAN_KEY, AMT
1000, 200
1001, 500
1002, 100
];

Straight table
For TICKET_NBR A1, TRAN_KEY 1000
Count(AMT) should be 2
Sum(AMT) should be 400
Count(TRAN_KEY) is 2 and it is correct
Sum(TRAN_KEY) is 2000 and it is correct
Same case with TKT_NBR A3 as well.
Kindly look into this and advise a solution. I have attached the qvw for reference.
Thanks,
Mahesh