Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an app where i want to change the data value based on the user input from the dashboard. Say i have the following table below. How would i go about setting up a dashboard to where they can filter on the ID and Attribute to change the Value and I cant utilize a QVD (company reasons) or vizlib writeback functionality. My initial thought is a variable input and partial reload but any guidance is appreciated.
ID | Attribute | Value |
1 | Color | Red |
1 | Age | 21 |
2 | Color | Green |
2 | Age | 48 |
3 | Color | Purple |
3 | Age | 36 |
If i select ID =1, Attribute = Color, Value change to Green then i want the table to read
ID | Attribute | Value |
1 | Color | Green |
1 | Age | 21 |
2 | Color | Green |
2 | Age | 48 |
3 | Color | Purple |
3 | Age | 36 |
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
When you see a new member with the "Community Manager" rank, it is our summer Intern, Caleb Lee! You will see him in many areas of the Qlik Community.
Caleb, entering his final year at Northeastern University, brings diverse skills and interests to our team. He is majoring in Business Administration with a concentration in Marketing Analytics and a minor in Computer Science and Film Studies. Beyond academics, Caleb is a big food enthusiast, enjoys working on small film projects with friends, and loves biking around Boston. A fun fact about Caleb is that the last show he binge-watched was Severance, which he highly recommends! Feel free to reach out; he loves meeting new people!
Please welcome Caleb to our team!
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!
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?
CodTransito | ID Vehiculo | PuntoCobro | FechaHora | Cumple? |
20056995 | V2 | 201 | 11-03-2024 08:57:14 | No |
20063584 | V2 | 101 | 11-03-2024 12:23:42 | No |
20072249 | V2 | 201 | 11-03-2024 16:33:01 | Yes |
20072418 | V2 | 101 | 11-03-2024 16:37:43 | Yes |
20092881 | V2 | 201 | 12-03-2024 09:55:24 | No |
20099617 | V2 | 101 | 12-03-2024 13:30:57 | No |
20110838 | V2 | 201 | 12-03-2024 18:42:12 | Sí |
20110960 | V2 | 101 | 12-03-2024 18:46:33 | Sí |
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,
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.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!