Welcome to Qlik Community

Bom dia, tenho uma tabela dinâmica, e preciso fazer uma combinação de duas bases de dados...

Em uma das tabelas temos:

Matricula do servidor | Lotação

Na outra tabela temos:

Matricula do servidor|Salário

Como ficaria para incluir dimensão que mostrasse por lotação, os salários dos servidores?

Hello all -

Does anyone have experience in implementing other Routing APIs beyond what Qlik offers? 

I've been looking at real time traffic offerings from Google ("directions api") and HERE ("routing api"). Although they come at additional cost, they potentially add value to our customers from a real time decision support point of view. We notice that GeoAnalytics routes tend to have rather "pessimistic" (slower) drive times when compared to comparable route times from other vendors.

We'll be doing a deeper dive into the implications, but was hoping that others may have dabbled in this area.

Thanks,

Martin Curtis

Hello all.

I am trying to figure out the measure expression for my bar chart. I want to get a count of the numbers of project each division has completed. The main fields I will be working on are "division", "project id", and "sub-status". 

I want to first groupby division and project id. If all the sub-status = 'completed' for the particular division/project id , then I want to add one to the count. How would I go about doing this?

Hi guys, need your help please

I need to create a loop that will scan \folder\folder\folder\ and find all possible .qvds 

and make a list of this . qvds 

Hi all

I am hoping someone can expand on this locked thread:

Rapid directory/file scan

I am wanting to get a list of the qvd file names within a folder. I appreciate I can use

  For each vFileName in Filelist (MyPathHere\*.txt')

     Load

         '$(vFileName)' as FileName

      From [$(vFileName)];

   Next vFileName

But i was hoping to be able to use the solution supplied by @gysbert wassenaar in the locked thread. Basically my question is if you dont have a myfilelist txt file, but a number of QVD files in a folder can the solution supplied by gysbert wassenaar be used?

Thanks

Scott

HI - 

I am using the 'Variable input' extension and I will like to create a variable input for a date.

Can the 'variable input' be used for a date ? If so, how ? 

Thoughts - jerry

HI All,

I have pie chart  wit level3 as dimension and expression as

NUM(Count(Id)/count(Total Id), '#,##0%')

I dot want to show the zero% in the chart . please find the screen shot below. please help