Recent Discussions
-
How to make the buttons pressed bydefault
Hello, Maybe you know a way that some of these buttons would be already be pressed by default? Because when i press them and later refresh I open the... Show MoreHello,
Maybe you know a way that some of these buttons would be already be pressed by default? Because when i press them and later refresh I open the sheet and its empty, I would like that some of the presses would be saved by default. How can I do it?
-
Alternative states instead of Tab Container in Qlik
Hello Guys,I am using tab container visual in qlik sense to show multiple objects in a single visual and in filter pane added all the charts so that i... Show MoreHello Guys,
I am using tab container visual in qlik sense to show multiple objects in a single visual and in filter pane added all the charts so that if i select particular chart from filter pane it show only that visual in tab container
But now my user wants to see like : Please add a way to compare between charts
Below is how my current chart looks like
How can I do this any suggestions, can I try alternative way, if yes how to do?
How about using alternate states
can anyone please help me on this -
Comparison between months using set analysis
Hi everyone,I need to create a line chart that compares each month to its previous month.The dimension is Year-Month (format: YYYY-MM).The metric shou... Show MoreHi everyone,
I need to create a line chart that compares each month to its previous month.
The dimension is Year-Month (format: YYYY-MM).
The metric should be the quantity of the month compared to the quantity of its previous month. There is a master measure called CountX that can be used.For example:
The model is filtered for the year 2025.
CountX for February 2025 is 100, for January 2025 is 80, and for December 2024 is 95.
Then in January 2025 I should see -15 (80-95), and in February 2025 I should see 20 (100-80).I tried using the Above function, but I am not getting data for January 2025, probably because December 2024 doesn't meet the filter criteria.
I couldn't solve it using set analysis.I would appreciate any help.
Thanks! -
Custom Total Calculation in Straight table
Hi all, I am new by Qlik Sense and facing some difficulty with an expression.I have a straight table visual containing the following columns 1) Rank ... Show MoreHi all,
I am new by Qlik Sense and facing some difficulty with an expression.
I have a straight table visual containing the following columns1) Rank ( Measure only limiting to top 10 ) 2)CustomerName (Dimension)
3)GSV_USD (Measure using Current year Revenue)
4) GSV_PY (Measure using last year Revenue )
When I add a 5th column to show Delta CY/PY % ; expression: Column(CY) - Column(PY) / Column(PY) ,
on rows level calculation is fine, but for total it is limited with the drop down options and when selecting SUM , it gives the sum of all column rows instead which is not correct, I target having something like the sum(column(CY)) - sum(column(PY) / Sum(column (PY)) keeping the context of the table (totals only for the top 10 customers)
Current Delta% Measure looks like :
if(dimensionality()=1,Column(2) - Column(4) / Column(4) , Missing Expression!! )Appreciate ur advice
-
Talend Remote Engine Job start failed
Hello, On Talend Remote Engine 2.13.9 we have this random error 1% of the time:Failure type: UNDEFINED_ERRORFailure message: org.talend.remote.commons... Show MoreHello,
On Talend Remote Engine 2.13.9 we have this random error 1% of the time:
Failure type: UNDEFINED_ERRORFailure message: org.talend.remote.commons.exception.ClientServerException: Remote server has encountered an error: , messageType=SERVER_ERROR, idRequestResponsePair=null, message=Job start failed because of parallel cleanup or deployment jobIdThis error is completely random, never the same task never the same time and only between 4 and 6 times a day.
We are not able to reproduce it because its random and around 1% of our runs
Let's see the logs for trying to understand step by step:
"Action 'deployJob' executed with success." => Deployment step OK
"starting job execution with 30 minutes timeout under task execution 65798xb7f803c2469667ae29:2.3/31f2e220-aea3-4f8b-b5e7-94878c38d2b7 " => Execution step OK
"starting job dx7f803c2469667ae2923 for task execution 31f2e220-aea3-4f8b-b5x7-94878c38d2b7""Remote server has encountered an error:
, messageType=SERVER_ERROR, idRequestResponsePair=null, message=Job start failed because of parallel cleanup or deployment jobId = dx7f803c2469667ae2923" => Starting step KOWe can see it can be :
1) "Parallel cleanup" => i look into the documentation and i didnt find anything about what is Parallel cleanup and how we can configure it...
2) "Parallel deployment jobId" => The job of this example hasnt have any another instance at the same time, its launching only 1 time a week and the last execution 7 days ago was finished ok with 1 minute duration...
More over, we don't want a same task be able to run in parallel and when this scenario is happening we have a "misfired task" launch status which is ok for us so its not about a parallel task execution
Does someone have an idea about the cause of this error ?
Thanks
-
Issue with Qlik Data Lineage Snowflake Connector
Hello, We have both Qlik Cloud Platform and Qlik Client-Managed. We installed Data Lineage on a server to enable lineage tracking for Qlik Client-Mana... Show MoreHello,
We have both Qlik Cloud Platform and Qlik Client-Managed. We installed Data Lineage on a server to enable lineage tracking for Qlik Client-Managed and Snowflake. The Data Lineage tool works well with Qlik Client-Managed, and we can retrieve traceability on Qlik Cloud.
However, the issue lies with the Qlik Data Lineage Snowflake connector. Despite following the documentation and using an admin account, the logs indicate that no lineage is being found. Below is an overview of the logs:
-
Qlik Enterprise Manager - Import Task dont work curl
HI, I review this documentationhttps://help.qlik.com/en-US/enterprise-manager/November2024/Content/EnterpriseManager/EnterpriseManager_APIGuide/CurlAP... Show MoreHI,
I review this documentation
I want to use import api rest method. But this dont work.
I use the sintax
curl -i -k -X POST --header "EnterpriseManager.APISessionID: wCo0_KvjEUFROvfHF5KGrw " --header "Content-Length: 3986" --header "Content-Type: application/json" " https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/tasks/SalesDBBackup?action=import" -T "C:\exports\ SalesDBBackup.json"
or
curl -i -k -X POST --header "EnterpriseManager.APISessionID: sMF7h0s6mLG6jBJvsRIvMg" --header "Content-Length:3986" --header "Content-Type:application/json" https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/tasks/SalesDBBackup?action=import -T "C:\exports\ SalesDBBackup.json"
It takes a long time to execute and produces the following error:
curl: (56) Recv failure: Connection was reset
thanks
-
Pull Assets from Jira to Qlik Sense
Hi,Currently, I have a connector to Jira, I use it to pull the Issues data per project,is there a way to pull Assets from Jira I don't see an option i... Show MoreHi,
Currently, I have a connector to Jira, I use it to pull the Issues data per project,
is there a way to pull Assets from Jira I don't see an option in the Qlik Web Connector.
Thanks,
Ido.
-
Automation In Qlik Cloud Analytics
Hi, I am using one of of the automation as a task chain where I have configured with 30 app reloads in a single automation but the problem is its gett... Show MoreHi,
I am using one of of the automation as a task chain where I have configured with 30 app reloads in a single automation but the problem is its getting timed out at 4 hrs. so planning to split the automation into two parts like 15 and 15.My idea here is that my second automation would triggered based on the first automation run is successful.
Any suggestions would be highly appreciated.
Regards,
Raju
-
Getting List of Data Files in a space.
Hoping to get a little insights for the community. We are utilizing an API call to get a list of the data files within a space: https://<Tenant>/api... Show MoreHoping to get a little insights for the community. We are utilizing an API call to get a list of the data files within a space:
https://<Tenant>/api/v1/data-files?connectionId=<SPACEID>
This works in providing the list, but some files are missing. There doesn't seem to be anything different about the files that are missing. They are QVD's that are created in the same app as some other QVD's that are showing up in the list. They are not significantly larger. There is no real difference between some of the files that show up and some of the files that don't show up. Has anyone else seen this or has anyone used a better method for getting a list of data file within a space? Any insights would be appreciated.