Hello,

I have a connection to one of core system's REST API set up. Everything including pagination is working fine for me. 

I am using WITH CONNECTION statement to adjust the URL in order to fetch data from different tables (entities) which REST API provides connection to.

Only issue here is, that it is really tricky for me to get all the field names which those entities include. My intention is to always fetch all fields from the table but SELECT * does not seem to work.

One workaround could be to obtain those field names from API using /describe method which API offers. This call returns field names which the particular table includes. But the issue here is that the result of this call in JSON looks e. g.:

"fields": {
"company_id": {
"type": "relation",
"required": true
},
"create_ts": {
"type": "datetime",
"required": false,
"default": "now"
},
"create_user": {
"type": "char",
"allow_blank": true,
"max_length": 30,
"required": false,
"default": ""
}

Which means that each field name is returned as table name (where the table itself includes field's properties like type etc.). And I am not able to get those chidlren table names returned as values so they could be used as field names in the following call to API.

Does anyone know about any workaround/solution?

I might have been missing something very simple as I am not so familiar with SQL.

Thanks a lot. Have a great day.

Hi All,

I am using variable parameter but its not working when passing comma (as comma act as a delimiter for a parameter), please suggest how to remove this error

In data editor
SET vScaleNumber=if(($1)>=1000000000, num(($1)/1000000000,'#,##0.0 B') ,
if(($1)>=1000000, num(($1)/1000000,'#,##0.0 M'),
if(($1)>=1000, num(($1)/1000,'#,##0.0 K'),
($1))));

in expression

$(vScaleNumber(Sum({<id={'a','b'}>} (sales*rate))))

Hi ,

We have perform an upgrade of our attunity servers .

Source Version

Attunity 6.6

Target 7.0

Snowflake Version is also upgraded to latest one  -- snowflake_linux_x8664_odbc-2.25.2.

Post this we are seeing that the tasks/ loads which used to run for 3 hours are taking longer time and its running for 52 plus hours.

We are seeing the slowness when used ATTREP_CDC_LOG table.

Attaching the logs with this and please let us know if any inputs are needed from our end here.

HI All,

Can we have option to display the measure to 1 decimal places, while the measure format is set to Auto.

As currently Qlik automatically shows the measure decimal points based on data for eg in some chart  measure is showing value upto 1 decimal point (10.12M) and in other chart its showing upto 2 decimal point (15.1M), So to make dashboard consistent this option will be really helpful.

So if there is option to show measure value upto 1 decimal point dashboard will be more consistent means both chart will show values like 10.1 M and 15.1 M respectively.

Hello all,  

I am having an issue with dates, as is everyone.  

I have a date loaded from a QVD, to which I don't have direct access.  

When I load the date, it shows in the Data Model viewer as an integer.  

After much searching and understanding, I got desperate and tried everything

[PA] :
NoConcatenate
Load 
 Date(num#([LBE Start Date])),
 Date(num([LBE Start Date])),

 Date#(num#([LBE Start Date])),
 Date#(num([LBE Start Date])),

 Date([LBE Start Date]),
 Date#([LBE Start Date]),

 Date(num#([LBE Start Date]),'DD-MMM-YYYY'),
 Date(num([LBE Start Date]),'DD-MMM-YYYY'),

 Date#(num#([LBE Start Date]),'DD-MMM-YYYY'),
 Date#(num([LBE Start Date]),'DD-MMM-YYYY'),
 Date#([LBE Start Date],'DD-MMM-YYYY'),
 Date([LBE Start Date],'DD-MMM-YYYY'),

 Date(Date#(num#([LBE Start Date]),'DD-MMM-YYYY')),
 Date(Date#(num([LBE Start Date]),'DD-MMM-YYYY')),
 date(date#([LBE Start Date],'DD-MMM-YYYY')),
 
 Date(Date#(num#([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
 Date(Date#(num([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
 date(date#([LBE Start Date],'DD-MMM-YYYY'),'DD-MMM-YYYY'),
 
 Date#(Date(num#([LBE Start Date]),'DD-MMM-YYYY')),
 Date#(Date(num([LBE Start Date]),'DD-MMM-YYYY')),
 date#(date([LBE Start Date],'DD-MMM-YYYY')),
 
 Date#(Date(num#([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
 Date#(Date(num([LBE Start Date]),'DD-MMM-YYYY'),'DD-MMM-YYYY'),
 date#(date([LBE Start Date],'DD-MMM-YYYY'),'DD-MMM-YYYY'),
*;
Load * resident [TEMP PA];

I am still not able to pull a date field from this.  In QS, my calendar date picker is not recognizing anything as a date.

Maybe I should give up coding 🙂

Hi!

I'm planning to install a new Qlik Sense Enterprise instance. It would be small, with no more than 8 users at a time and around 4 or 5 apps, so i was thinking on making the deployment in a Windows 10 machine. I've read in the Qlik Sense website that W10 is supported but is only recomended for testing and development. My question is if is there someone has experience or can give testimony of a QS Enterprise deployment on Windows 10 for production purposes.

Any help will be appreciate.

Thanks in advance. 

Good morning,

We are using Qlik Replicate to pull data from iSeries to BigQuery. There is a "bulk insert" error occasionally occur made tasks fail. After resuming  tasks using "Resume processing..." in the web GUI, the tasks keep running fine until the same error occur some days later.  That cycle repeats again and again.

The tables in BigQuery still populated and look good but the error keep pushing up every day raise our concern.

Please advise.

[Details]

In this example, we have GQSUDC table (same name in iSeries and BigQuery) and GQSUDC__ct (change tracking version).  Checking the log file in Qlik replicate, we learnt that the error occurred when Qlik insert back data from attrep_changes table to GQSUDC__ct. There is a "invalid timestamp" error (red highlight in below error message).

Error message from log file:

Failed (retcode -1) to execute statement: 'INSERT INTO `quotedb_raw`.`GQSUDC__ct` (`header__change_seq`,`header__change_oper`,`header__change_mask`,`header__stream_position`,`header__operation`,`header__transaction_id`,`COMPNUM`,`POLNUM`,`SDUSER`,`SDCODE`,`SDSTAT`,`SDACTY`,`SDRRPL`,`SDRTAP`,`SDGRP`,`SDDISPLAY`,`SDVERIFY`,`SDASSN`,`SDTABL`,`SDSDTY`,`TRANSCTION_TYPE_FLAG`,`SDUNIT`,`SDDRVR`,`SDDEEF`,`SDDENT`,`SDRDIS`,`SDDAMT`,`SDPAMT`,`SDPRDS`,`header__timestamp`,`SDSTMP`,`DATA_EXTRACT_DATETM`,`DATA_LOAD_DATETM`,`RRN`) SELECT CAST( `attrep_changes789B3994BFC808E3`.`col1` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col2` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col3` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col4` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col5` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col6` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col7` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col8` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col9` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col10` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col11` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col12` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col13` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col14` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col15` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col16` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col17` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col18` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col19` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col20` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col21` as STRING) , CAST( `attrep_changes789B3994BFC808E3`.`col22` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col23` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col24` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col25` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col26` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col27` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col28` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col29` as NUMERIC) , CAST( `attrep_changes789B3994BFC808E3`.`col30` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col31` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col32` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col33` as TIMESTAMP) , CAST( `attrep_changes789B3994BFC808E3`.`col34` as INT64) FROM `quotedb_raw`.`attrep_changes789B3994BFC808E3` WHERE `attrep_changes789B3994BFC808E3`.`seq` >= ? and `attrep_changes789B3994BFC808E3`.`seq` <= ?' [1022502] (ar_odbc_stmt.c:2783)
00005539: 2022-06-30T01:28:30 [TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 42000 NativeError: 70 Message: [Simba][BigQuery] (70) Invalid query: Invalid timestamp string "0000-22-00 00:00:00.000000" [1022502] (ar_odbc_stmt.c:2789)

Thanks,

Dat

Hey everyone,

I'm trying to do something that seems to be simple, but I can't get the dates to ever be equal.

Here's a simple table:

PROJECTSTATUS:
Load PROJECTID,
PROJECTNUMBER,
STATUS,
STATUSUPDATE,
date(HIDATE, 'M/D/YYYY') as HIDATE,
Time(HIDATE) as HITIME;

I want to create a flag that shows 1 or 0 in a table column depending on if the project status was updated this month or not.  I can't seem to get the date to match even with something simple like:

=if( [HIDATE] = '6/27/2022', 1, 0)  or   =if([HIDATE] = date(6/27/2022), 1, 0)

it's always false:

Appreciate any ideas on how to get these to equate!  Thanks!