Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Est-il possible de personnaliser l'affichage des filtres sélectionnés par l'utilisateur sur une feuille/application Qliksense ?
Par exemple :
On a un filtre ANNEE contenant 6 valeurs d'années, si on applique le filtre sur 3 années (2019, 2020 et 2021) - ( cf. ANNEE.PNG) au lieu d'avoir le nombre de sélections faites au niveau de l'entête de la feuille (cf. FILTRE_ANNEE.PNG) avoir plutôt le contenu exacte des sélections qui ont été faites comme ça se fait sur Qlikview (cf. QV_FILTRE.PNG) et avoir également la possibilité d'appliquer des couleurs selon les dimensions du filtre.
merci par avance.
Team,
Suddenly i am getting unauthorized error in Entitlement Analyzer, App Analyzer, Access Evaluator and Reload Analyzer. Attached the screen shot for reference. Please help on this
Thanks
Farsana
Hi,
I am trying to find a listing of all Named CAL QVW authorization assignments. This would be similar to how we can find the list of each document CAL QVW authorization from the CalData.pgo file (CalData/PerDocumentCalData/PerDocumentCalData). I would like to obtain similar per-document authorization data for the Named CALs and cannot find how to do so.
We have a variety of named user CALs assigned. We use DMS authorization. Some Named CALs are assigned to usernames that are available in a configured QMC directory. Other named CALs are assigned to external usernames that are connected to the Access Point via external SSO.
I know that I can obtain a simple list of the current Named CALs with CalData/NamedCalsAllocated/CalAllocEntry. However, I cannot find a way to query what documents those named CALs are assigned to. I highly suspect that this information is available somewhere because I can find it on the QMC. In the QMC, if I go to the Users tab and search for a given named User, the resulting Documents list will show me all of the documents which that named CAL is authorized. I am essentially trying to obtain this same output from the server files themselves.
The reason I am looking for an external server data source is because I can only query the QMC for users that exist in one of my directories. For external SSO users, they do not appear in the QMC because it can only search by QMC connected directories.
Please let me know if I can clarify anything and thank you in advance for your assistance.
Hi Team,
If the latency is due to high volume of data, then how would you trouble shoot it or what are the optimizations we can perform on it. And what are the data validations scripts we have. or how we can do the data validations.
Thanks
Hello:
We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as it is being replicated?
Thanks,
Manas.
Hi All,
I have a combo chart and need to show the data points inside the circle like in this picture. Please help me is there is any option to do that? or any extension object is available?
Hi team,
I have a doubt regarding creating filter conditions for a column, in the attached image I have used two filter condition, I'm having a requirement were I want to use more number of filters that maybe in thousands(using python API QEM) , is it possible or can I know whats the maximum number of filters I can use.
Thankyou
Regards
Sreehari
Hi.
I'm hoping someone can suggest what may be going wrong with our Qlikview QMC tasks.
Back in March, we noticed that the tasks to reload our QVWs started to fail from time-to-time. The only change to anything prior to these failures was the databases were moved to a new server. The ODBC connections were changed (and successfully tested).
The tasks always fail with a Timeout error. Mostly on trying to save the qvw. The reloads are like this:
1. Reloads a qvw in a production processing folder.
2. Does a binary load of the qvws which are accessed on AccessPoint by the users.
No user has direct access to any of the qvws (so no locking issues that I can find). We have NPrinting, but the tasks run overnight and the issues we're experiencing with the QMC Tasks occur at all different times of the day.
Reloading the qvws manually on the server works every time. The qvws take around 6 minutes to load, the binary load is just seconds.
The CPU on the server gradually gets to 100% (the Qlikview Distribution Service is the culprit here - with sometimes 7 or 8 open when I look at Task Manager). I usually have no success trying to stop or restart the service at this point and usually end up rebooting the server.
The version is Qlikview 2018
There are 2 servers in a cluster
The qvw files are on a mapped drive held on a different server
Operating System: Windows Server 2019 Standard
Server1 has 11 CPUs
Server 2 has 7 CPUs
Reloads are limited to 4 at a time
I've tried several things:
1. Changed the timeout limit to 1 hour (it was on 6 hours)
2. Changed the reload tasks to load every 2 hours (it was 30 mins)
3. Tested that the qv admin account has access to all relevant folders
4. Ensured that the Section Access includes the qv admin account
5. Added a wait after the main qvw reaload (30 seconds) on the offchance that this may help before the binary load is started.
The main problem is that this seems to be sporadic. A qvw will load fine all day and then fail several times (sometimes concurrently, other times it will run, fail, run, fail etc).
This is a sample of the log of one of the binary loads which failed earlier today (I removed the middle part of the log to just include the start and end parts). If anyone can suggest things to try, I would appreciate some help.
Thanks in advance.
(06/05/2024 10:57:50) Information: DistributeTask[bc0170ce-6b05-4cea-9ded-b716992d265a] ("Live/App1.qvw"): TryStart - Starting task. Triggered by 'TaskCompletedTrigger'. Id:5ae7c38c-7412-4bd6-a115-91d9f992edcc. ExecID:52182c24-55fc-46a0-8575-038cc376ab44
(06/05/2024 10:57:50) Information: Entering Task Execution.
...
(06/05/2024 10:58:04) Information: Reload finished successfully
(06/05/2024 10:58:04) Information: Start saving document
(06/05/2024 11:57:50) Information: Closing the document.
(06/05/2024 11:57:51) Error: The sourcedocument failed to save.. Exception=System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. || at QlikView.Doc.SaveAs(String _FileName, Int16 _Format) || at QVBWrapper.Document.Save(ILogBucket i_LogBucket, String i_SaveAsFileName)
(06/05/2024 11:57:51) Information: DistributeTask[bc0170ce-6b05-4cea-9ded-b716992d265a] ("Live/App1.qvw"): TryAbort. Triggered by 'RunTimeTrigger'. Id:0000000a-000a-000a-0a0a-161616161616. ExecID:a4709667-398c-4d53-b268-aaffbbdfd7ea
(06/05/2024 11:57:51) Information: Closed the QlikView Engine successfully. ProcessID=428304
(06/05/2024 11:57:51) Error: The task "Live/App1.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.TaskTimeOutException: Task <Live/App1.qvw> has timed out || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)
(06/05/2024 11:57:51) Information: Task Execute Duration=01:00:01.1283403
(06/05/2024 11:57:51) Information: Sending Alert mail
(06/05/2024 11:57:52) Information: TaskResult.status=Finished
(06/05/2024 11:57:52) Information: Notifying all triggers of new state: "FinishedWithErrors"...
(06/05/2024 11:57:52) Information: Notifying all triggers of new state: "FinishedWithErrors" - Completed
Hello, i need help please :
i have the following data :
ORD_Number | MOV_Material | MOV_Reference |
5102742773 | 5009583994 | 76840059 |
4041989847 | 76840059006_0393 | |
4041989973 | 76840059007_0393 | |
4041990003 | 76840059002_0393 |
FOr exemple, i passed a command with mov_reference 76840059, that generated me a ORD_Number 5102742773.
Later on, i had a problem with my command (76840059). i created 3 new lines (76840059006_0393, 76840059007_0393, 76840059002_0393) that represents the Mov_Reference of each problem i had. By Default, there is no ORD_Number Attached to theses lines.
Also note that the first 8 caracters of these 3 lines represents the initial mov_reference 76840059.
Note that this is just an example, i have many commands in my data source
In qlik, i want a code that will help me replace the empty values or null values in ORD_Number by that of the original MOV_Reference, for each MOV_Reference
here is the result at the end :
ORD_Number | MOV_Material | MOV_Reference |
5102742773 | 5009583994 | 76840059 |
5102742773 | 4041989847 | 76840059006_0393 |
5102742773 | 4041989973 | 76840059007_0393 |
5102742773 | 4041990003 | 76840059002_0393 |
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!