Hi all,

I'm using the google maps api key a few years now. This was working fine. Only since this week It isn't working anymore.

This is the script:

LOAD
'$(vStation)' as STNR,
'$(vStationsnaam)' as Stationsnaam,
'$(vStationsnaamlang)' as Stationsnaamlang,
'$(vCustomer)' as Customer,
'$(address)' as Address,
'$(vCountry)' as Country,
[result/geometry/location/lat] as latitude,
[result/geometry/location/lng] as longitude
FROM [https://maps.googleapis.com/maps/api/geocode/xml?address=$(address)&key=MyKey] (XmlSimple, Table is [GeocodeResponse]);

If I put the created url in the webbrowser I'm returning this message:

Who can help me with this?

I have a client that is switching to  the Qlik AMP licensing.   The are still running nprinting 16 and need to continue to do so because of some complex report distribution processes.    Is the any implications related to the nprinting 16 when switching the servers over to AMP based signed license keys?

Thanks in advance

Team,

Now suppose if I make any selection in Year Month or Plant, Figure not affected in Pivot Table. So need expression for the same. Please find the attached QVW for more reference.

Thanks

Hello guys,

I created a variable called vAirComp1, with the following expression in order to collect the first item selected on the field called NCIA.

=SubField(GetFieldSelections(NCIA, ' - ', 5),' - ',1)

And once the user can select as many NCIAs as possible, I'm using the following background color expression in order to color my chart line based on the user's selection (vAirComp1 value).

if(vAirComp1='AZU',RGB(14,43,88),
if(vAirComp1='GLO',RGB(255,112,32),
if(vAirComp1='PTB',rgb(255,213,3),
if(vAirComp1='ARG',rgb(0,173,239),
if(vAirComp1='SKU',rgb(89,35,127),
if(vAirComp1='VVC',rgb(255,219,0),
if(vAirComp1='EFY',rgb(254,118,17),
if(vAirComp1='BOV',rgb(13,42,98),
if(vAirComp1='BWA',rgb(175,38,120),
if(vAirComp1='RPB',rgb(103,51,205),
if(vAirComp1='NSE',rgb(211,52,53),
if(vAirComp1='SRU',rgb(74,90,97),
if(vAirComp1='FBZ',rgb(254,190,16),
if(vAirComp1='THT',rgb(45,204,211),
if(vAirComp1='VTA',rgb(223,0,43),
if(vAirComp1='ECO',rgb(0,173,238),
if(vAirComp1='ACL',rgb(108,18,64),
if(vAirComp1='VCV',rgb(239,126,42),
if(vAirComp1='DAP',rgb(45,45,46),
if(vAirComp1='ROR',rgb(253,230,0),
if(vAirComp1='RYL',rgb(11,70,150),
if(vAirComp1='SRC',rgb(38,73,110),
if(vAirComp1='TGY',rgb(0,35,93),
if(vAirComp1='SID',rgb(47,57,117),
if(vAirComp1='MWM',rgb(147,200,70),
if(vAirComp1='JAT',rgb(158,32,45),
if(vAirComp1='WAY',rgb(103,51,205),
if(vAirComp1='AZN' or vAirComp1='AZP',rgb(0,166,81),
if(vAirComp1='AVA' or vAirComp1='TPA',rgb(2219,19,25),
if(vAirComp1='LAN' or vAirComp1='LCO',rgb(230,51,88),
))))))))))))))))))))))))))))))

But as you can see, there are lots of IFs statements...

Is there any better way of doing this?
I'm pretty sure I'm not using the smartest solution... 😁

Any ideas?

Thanks

Dear 

I don't understand it.

Sentence recorded in the Qlik Sense release note.

What is the meaning of FoTF in this sentence?

"Some FoTF in SetExp not always evaluated correct"

Please explain it.

I'm looking for a way to dynamically search a field on the front end to see if all the values have a shared sequence. I don't want to provide it to search but rather it is found dynamically. For example, if I had the below data and the application is filtered to 'A' on [Grp] it would return 'SMTH - ' but unfiltered it would return '' or Null().

Grp | Text Value

  A   |  SMTH - 1E

  A   |  SMTH - 2W

  B  |   WPQV - 2A

  B  |  5N

Thanks in advance for your help/thoughts.

I have a data set:

ID

StartDate

EndDate

I want to create a bar chart with date on the x-axis and a count of active IDs on the y-axis but need to do it in the app not the loader.

I know I can do this by creating a new table in the data load editor by doing:

[ActiveDates]:
noconcatenate LOAD
ID,
date(StartDate+IterNo()-1) as ActiveDate
while date(StartDate+IterNo()-1)<=EndDate;
load
*
resident DataTable;

but there are approx 5 million IDs and each has something between 1 year and 5 years worth of dates to iterate over so this is not a  practical resolution.