Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
(Apologies, this was posted earlier but was my post was so full of flaws, I removed it).
I am trying to show a graph of tickets raised over a periiod of time. In my data I have zero 'Open' tickets in October and as a result October does not show on my graph.
I have tried a 'Master Calendar' which works until a filter is applied. -
I have also read about adding + sum({1}0) to my measure.
Count({<[Status]={'Open'}>}id) + sum({1}0)
and setting the Addons -> Data Handling -> Include zero values
Any help would be appreciated
We can only see the usage on the app level using the Entitlement analyzer, but we cannot track the sheet usage, is there anyway to do it on SaaS? I know it's possible on Enterprise.
Hi,
Recently I set up a DataBricks Connection but unable to access the databases inside the Catalog.We are in May 2023 Patch 6 version of Qliksense. But the same connection could be accessed through SAAS. Please help.
I have created a GET REST connection to NPrinting and it works perfectly. This is the GET REST Connection Setup...
My problem is that I am not able to set up a POST REST Connection. Everything is the same, except for the Method and the Trusted Locations, which has been loaded into NPrinting.
I managed to get the POST working in Postman, by first doing a GET login. Then copying the XSRF-TOKEN out of the Cookie and adding it to a X-XSRF-TOKEN key under Headers.
This was a manual workaround, the problem is how to do it when setting up a Qlik Sense POST REST login connection... I can't get the XSRF-TOKEN to add it to the connection, to get the connection to authenticate, i.e., not give the 403 (Forbidden) error...
We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load is going success the job is failing with the error Failed to rename file repcmd.log to repcmd__240417043324.log .
Preciso achar o Valor da Coluna 1 * Coluna 2(Relativo). Mas não estou conseguido.
Preciso criar um set analysis que trate (Pois o valor correto é diferente).
Preciso de ajuda.
Cod | Valor | Rank(Relativo) | (Column(1) * Column(2)) / 1000000 (Errado) |
Valor Correto |
2061 | 300000 | 4,69% | 9.689,40 | 14.070,00 |
5277 | 300000 | 21,21% | 43.817,70 | 63.630,00 |
5543 | 300000 | 3,36% | 6.932,70 | 10.080,00 |
10757 | 300000 | 7,27% | 15.025,80 | 21.810,00 |
12305 | 300000 | 4,10% | 8.461,80 | 12.300,00 |
13248 | 300000 | 3,01% | 6.213,00 | 9.030,00 |
13697 | 300000 | 11,97% | 24.739,50 | 35.910,00 |
16923 | 300000 | 6,23% | 12.882,30 | 18.690,00 |
17459 | 300000 | 24,93% | 51.509,10 | 74.790,00 |
19201 | 300000 | 5,18% | 10.710,90 | 15.540,00 |
19303 | 300000 | 6,45% | 13.333,80 | 19.350,00 |
29976 | 300000 | 1,60% | 3.307,50 | 4.800,00 |
300.000,00 |
Hey folks.
I have a situation where I need to join a bunch of similar, but not identical, report files into a single.QVD. I've been renaming headers with python before loading but now my boss wants me to get rid of the python step and do it all in Qlik.
The issue is that it's a bunch of .CSV files with slightly different header names. For example "Customer #" vs "Customer number" vs "Client No." There's no option to get these to come in harmonized because they're from different vendors.
I was trying to do something like: Load Distinct If(exists('Customer #'), 'Customer #') as CustomerNumber If(exists('Client No.'), 'Client No.') as CustomerNumber
But I get an error about the headers not being unique even though I'd expect the If() to return nothing when the Exists() condition fails.
Moving the "as CustomerNumber" inside the If() statement is a syntax error.
Is there a way to do this without making temporary tables and conctenating? I'm now doing it this way and it's working but it seems inelegant and like it's more steps than should be needed.
Thanks!
Hello everyone,
We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.
We would like to be able to access these servers via ourdomain.com/qliksense1 and ourdomain.com/qliksense2.
Is it possible to configure Nginx to allow this?
Furthermore, we also require virtual proxies for some of our custom apps and we would like to be able to access the virtual proxy via ourdomain.com/qliksense1/virtualproxy and ourdomain.com/qliksense2/virtualproxy.
Is this possible?
Thank you!
Greetings!
I am looking for the most recent version of the document titled "Natural Language Query Features", December 2019. Please see attachment of the doc I am referring to.
Cheers,
++José
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.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
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!