Hello,

I have a issue with these data, i need to create Cumple? field, the rules is with the same id_vehiculo, with different CodTransito and PuntoCobro, the difference between fechahora(1) and fechahora(2) is <= 20 minutes

How can i do these?

Hello, I am trying to get a Month-Year field from SCHEDULEDDTM, see below.  An example of the format for SCHEDULEDDTTM is   2022-01-01 00:00:00.000000

I am only able to get the first row to display correctly:

My code to get this is:

date(monthstart(SCHEDULEDDTTM), 'MMM-YYYY') as SCHEDULED_YEAR_MONTH

How do I achieve this?  Please help, thank you!

From UI, it is easy to select all tables.

However, if I manually input a json task file, is there a way to define migrating all tables? Instead of adding a list of tables to "explicit_included_tables"?

Hello.  I am looking to be able to search for null/empty values in the web view.

*string* works for everything, but I cannot figure out a way to search for nulls.

I want to filter to the values equal to dash/hyphen/null

Any help would be great

Hello,

Just wondering if this "works as designed" or if it's a bug. In Qlik Sense Enterprise, when you go into an app's settings and select Disable Sheet Header, the nav icons "<>" are no longer present. This may seem obvious, but I was told by someone that in Qlik Sense Cloud, they appear in a different location.  So I was wondering if that claim was true and if they should also be visible in Qlik Sense client-managed as well. 

Thank you

Steve

Hello,

I am working on converting a QlikView Dashboard to Qlik Sense.

In the QlikView Dashboard they have a trigger on the Open Document to select values into fields.

I don't see this option in Qlik Sense Aug 2022.  I know that we can use Actions on sheets but this is not an exact match.

Is there a good work around?

Thank You,

Michael

hi all,

I am trying to set up an external task to run .bat file from the qmc but not working for me nor I can see why.

I am able to run the task by double clicking to it using the Qlik service account with no issues. Any idea what do I need t do differently?

Hi,

I'm trying to build a map to display the location of our customers. Initially, I was trying to use the density layer, but the result kinda sucks and when zoomed out it displays a big symmetric colorful circle (idk if I did something wrong, but I was hoping it'd properly fill the map, instead of overflowing to the sea).

Then I tried to use the point layer, which did the job and I found to be better to our purposes, but is limited to 50k point. At this point we have 500k+ customers, and even tho I could filter the data (I have 2 area layers that I uploaded as GeoJSON and works), it'd be cool to view the frequency in the whole country when nothing is selected).

Having so many data points makes my map laggy so it does make sense limiting to 50k. I saw some stuff about clustering the data with GeoOperations. Tried that aswell, without success because it's limited to a 100k rows table (my geo table has 1.5kk rows and carries most of the zip codes, streets, etc.)

I'm just not sure how to proceed. If anyone could give me a direction I'd be thankful.

So far, the map looks like this when unfiltered and zoomed out (displaying every store and max customers possible):

When zoomed in and with a state selected it will show the second area layer (the state "intradivision"):

This is the best I could do, but it's very laggy and therefore useless.

How can I achieve something similar and have a better performance? Should I cluster the customers by proximity? How? Should I use density layer instead? Why?

Any help is appreciated.

Team,

I am new to Qlik and I am struggling on functions e.g. aggr() and count() not sure how to achieve the following?

Data:

1, PERSON1, 4/1/2024

2, PERSON1, 4/3/2024

3, PERSON1, 4/10/2024

4, PERSON2, 4/1/2024

5, PERSON2, 4/2/2024

6, PERSON1, 4/11/2024

Below is the desired output:

Person1: 5 Occurrences in April

Person2: 2 Occurrences in April

Similarly for the other months......

Any help would be appreciated! Thanks in advance 🙂

Kindly advise which kind of charts should I use for getting these box containers in Qlik sense.  Need this kind of box chart which contains Circle with color and scale with Avg and reporting month