Hi all,

Silly question this one.

Please paste the below code in an empty QlikView file. My Code fails on the 'Match' statement. I need some assistance to get this to work please, and I've tried all options I can think of.

Thank you

Tbl:
load
chr(40) & concat(Code, ',') & chr(41) as Codelist;
LOAD * INLINE [
Code
28
29
30
];
Let MyVar = FieldVAlue('Codelist',1);
drop table Tbl;

DemoData_1:
LOAD * INLINE [
Student, Code
Peter, 28
Pam, 88
Paul, 30
];

DemoData:
NoConcatenate load
*
Resident
DemoData_1
where match(Code, $(MyVar)) > 0 ; //this is where it fails - I've also tried $(MyVar), with no luck - it runs, but returns nothing

drop table DemoData_1;

exit SCRIPT

We have a SAP Extractor replicate job built over a standard SAP HR extractor. When executed without any selection criteria  over SAP RSA3 transaction, there is data in the extractor. However, we don't get any data out of Replicate tas.k Any suggestions on what might be causing this issue ?

SAP -

Replicate -

Hi folks,

I have to move all the QVDs from Spaces to the Shared space - I have seen various articles on REST calls, powershell scripts to make API calls - I implemented in Postman a simple to get a list of spaces and although it kind of works it couldn't get all of the spaces we have. I have checked the spaces one by one for permissions and the account I use has all of the permissions available so I don't believe that is the issue - is there a bug in the API or more probably am I calling it incorrectly?

In postman I use the bearer token, newly created in case that is the issue, then the URl is 

https://XXXXX.qlikcloud.com/api/v1/spaces/

The resulting JSON  only pulls 10 spaces but I have 30 - is there something else I need to do to get the full list?

Thanks

Hi,

QS is behaving strangely after the upgrade Feb2018 enterprise to Apr2019 enterprise (but also in my Feb2019 Desktop).

When exporting a table to excel, the cells which contain a zero are represented as blank. The value is present in the cell (you can see it when you click on it) but it happears as blank.

if you look at the format in xls you see the following:

This is the code I used to create a table containing numbers from 0 to 9:

load RowNo()-1 as riga
AutoGenerate 10;

It does not happen if I slitly change the code to:

load (RowNo()-1)/3 as riga
AutoGenerate 10;

In this case the format in excel is the generic one:

1) Has anyone experienced the  same issue?

2) Is there any way to fix it for the entire app? Maybe using some kind of variable similar to MoneyFormat. I have thousands of fields and it is unthinkable to change the format one by one.

Thank you for your support.

Hello,

I have created a mashup using sense object id. so far everything working fine the only issue I was facing is when I am pulling the map object id inside the <div> the map size gets small (maybe zoom) but when I load the page again everything gets normal.

There is something wrong with click map behavior don't know why this happening.

Any help?

Not a major issue but since the SR4 release when I preview an Excel report using the designer, sometimes the excel window jumps out of the designer frame and into it's own Excel tab in task bar. 

If you accidentally close the excel window then the only way to close designer is ending task via task manager  - because of the continuous error "The RPC server is unavailable".

nPrinting May 2022 SR4

nPrinting  Designer May 2022 SR4

Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20214) 32-bit

Windows 10 Pro 21H2

Any advice?

Thanks