Hola, 

Soy nuevo en el USO de Qlik y Ultimamente tengo un problema con la Base de Datos y no se si tiene que ver con Qlik o no. Necesito saberlo para intentar tirar por una vía o por otra a la hora de solucionar el problema. A ver si alguien me PUEDE Ayudar a solucionarlo.

Una vez a la semana en La Tabla tempdb de la BASE DE DATOS Donde está alojado Qlik y el ERP de la Empresa se llena de Manera considerable ralentizando el Funcionamiento de la Misma y del ERP. Queria sable si el Llenado Masivo de tempdb se Dębe al USO de Qlik O Este no utilizació esa tabla para nada.

Gracias, un saludo.

How can I merge the following two expressions into one?  Thanks  you!

sum({<T3.DateC= {">=$(=AddMonths(Max(T3.DateC), -11))"}>})

Count({<[T3.Amount]={">=$(V1)<=$(V2)"}>}distinct[T3.VendorID])

I have a situation where I have Vehicle related data in a table. In the table, among other fields, I have the Registration, Transaction Date and Amount. Once per month there is a Vehicle Lease Transaction around the 25th of the month. Although we are 2019-07-16, the last transaction was on 2019-06-25. Over time the lease amount can increase or decrease. I need to show only the latest Lease Amount. 

Among many tried expressions, this one is the closest, but still not correct. I have tried removing the [-] before the [Transaction Date] but this does not appear to make a difference. 

Aggr(firstsortedvalue({<DateType={'Daily_Data'},tx_Summary={'LEASE'}>} Amount, -[Transaction Date]), [Registration Number])

Please can you show me where am I going wrong with this? Thanks. 

Hi!

I would like to calculate the balance of enterprises which is the substraction of the new and the closed enterprises. Here is the2 expressions for the new and the closed enterprises:

=Count(distinct {< [Municipality_Unit-municipality_name]= {'ΧΕΡΣΟΝΗΣΟΥ'}, [mitroo-03072017.Registration_Number] *=E({<[mitroo-03072017.Date] ={"$(=Maxstring({<[mitroo-03072017.Registration_Number]>}[mitroo-03072017.Date]))"}>}) >} [mitroo-03072017.Registration_Number])

=Count(distinct {< [Municipality_Unit-municipality_name]= {'ΧΕΡΣΟΝΗΣΟΥ'},
[mitroo-03072017.Registration_Number] *= E({<[mitroo-03072017.Date] ={"$(=MINstring({<[mitroo-03072017.Registration_Number]>}[mitroo-03072017.Date]))"}>})
>} [mitroo-03072017.Registration_Number])

I tried to put a minus between this 2 expressions to do the difference but it doesn't work. Any idea?

Thank you!

Hi Team, 

Does using the Vizlib KPI extension for executive designs , will it decrease the performance or using of the Vizlib extension normally will it decrease the performance?

Kindly help me regarding this.  

Hi, I keep getting the 'Field Not Found Error - Field ShipperCountryCode Not Found' when I run the below script. I have used the If(len) formula as I wish to replace the data in a field if another field contains a value. Any ideas?

//===SHIPPING ORDER===

[Shipping Order Number] as MatrixSO,
[Port of Loading] as PoL,
[Port of Discharge] as PoD,
date(floor([Expected Ship Date])) as ExpShipDate,
Upper([Service Level]) as ServiceLevel,
[Path Type] as MatrixPathType,
INCOTerms,

//===SHIPPER===
[Shipper Name] as ShipperName,
[Shipper Alias] as ShipperAlias,
//[Shipper Country Name] as ShipperCountry,
//[Shipper Country Code] as ShipperCountryCode,
//[Shipper City] as ShipperCity,
[Shipper State] as ShipperState,
//[Shipper Postal Code] as ShipperPostalCode,
[Shipper Region Name] as ShipperRegion,
[Pick Up Location Name],
[Pick Up Location Alias],
[Pick Up Location Country Name],
[Pick Up Location Country Code],
[Pick Up Location City],
[Pick Up Location State],
[Pick Up Location Postal Code],
[Pickup Location Region Name],

// For each country, the tradelane identifier has to be entered in the input file
applymap('Tradelane_map', ShipperCountryCode, 'n/a')
& ' to ' &
applymap('Tradelane_map', [Delivery Location Country Code], 'n/a') as Tradelane,



// For non-UK origins and destinations, the rates are stored without any characters (eg. not '5469 VV' but '5469').
// In order to define the correct %RateID (see below), we need to purge the shipper and delivery postal codes
// outside UK from any non-numeric characters
IF(ShipperCountryCode = 'GBR',
ShipperPostalCode,
KeepChar(ShipperPostalCode, '0123456789')) as ShipperPostalCode_purged,

IF([Delivery Location Country Code] = 'GBR',
[Delivery Location Postal Code],
KeepChar([Delivery Location Postal Code], '0123456789')) as DeliveryPostalCode_purged,


if(len([Pick Up Location Country Name])>0,[Pick Up Location Country Name], [Shipper Country Name]) as ShipperCountry,
if(len([Pick Up Location Country Code])>0,[Pick Up Location Country Code], [Shipper Country Code]) as ShipperCountryCode,
if(len([Pick Up Location City])>0, [Pick Up Location City], [Shipper City]) as ShipperCity,
if(len([Pick Up Location Postal Code])>0, [Pick Up Location Postal Code], [Shipper Postal Code]) as ShipperPostalCode




FROM
[Input\Shipping_Order_Extract-week 27.xlsx.xls]
(biff, embedded labels, table is Results$);

Hi, 

I have some experience with Qlikview, I just need some help with the following

I have table of product data ( Tabel 1) , I  have created a table (Table 2 ) that links to that (Table 1) based on  field ATC and I need to perform certain exclusions based on requirements in the second table. I have attached a small set of the data with examples of the tables below. (There are multiple disease in the attached document, if it was only one disease then i could use set analysis, but since there are over 200 diseases in the complete dataset I don't think set analysis would work? Maybe I am thinking about it all wrong)

Thanks in advance Atila

Table 1

Table 2

Hi,

I searched google and the forums as well, but didn't find good directions how I can set more than one dimensions (sometimes I need to set up to 4 dimensions) with a button. I am currently can switch only one dimension. Even if I use the second action and try to set another dimension (which would bring me up to 2 dimensions) this doesn't work but QlikSense only sets the second action then.

Can you give me some directions how to do this?

I am trying to create a vertical stacked bar chart, where the only dimension selected in the chart is a datetime field. The Horizontal axis is not being sorted by this variable FIRST. It is being sorted by an unspecified field, the server name, before it does the AVERAGE aggregation by the datetime field.

I have not figured out how to force the sorting by the datetime field, either by expression, numerically or alphabetically and combinations thereof.

This should be simple, right?

Yellow is DEV server, Red is PRD server and Green is UAT server. Datetimes in green are not represented in yellow are in the green area. The red datetime is in neither the yellow or green. I believe the average aggregation is working correctly in the yellow area when there is data for both DEV and UAT servers for that datetime.

Ideas?