Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate.
Erreur veut dire que l'adresse host et le numéro du port pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK .
Cordialement.
Cordialement.
Hello,
I am trying to create a table in Qlik Sense which is similar to the one below. But I am unable to do it because I cannot pick previous value from the resultant row and use it to calulate the next value in the same column.
Table:
In the above table, Availability is what I am trying to calculate. Formula for that would be "Column A-Column B" for priority 1 which will be 30 hours here for project 1. Then for priority 2, Result will be 30-3=27 i.e., Total Reult hours minus the hours required for 1st priority project. Then for the 3rd priority it will be 27-1=26 and so on. Question is how to use the value from resultant (Result) column to calculate the value for next row in the same column. Is there a function for this?
Thank you,
Apoorva.
Hi,
I have created one KPi where it has some value and its changing based on that selections applied.
Now in qlik sense if we apply the cycle for the same filed selections then the value is showing wrong or showing value and so on.
For example if value is showing as 2 in Qlik sense kpi, then the same kpi is showing as 2.13333333333333 in Nprinting pixel perfect report generated.
any suggestions would be appreciated.
Hello Everyone,
I have a requirement to upsert a list of contacts with an external id (LP_ExternalContactId__c) and also need to relate to the account with another external id (LP_ExternalClientId__c). I am using tSalesforceOutputBulkExec (Bulk API V1) for this as I have to do a retry mechanism on failure. So the first try is in Parallel concurrency mode with a bigger batch size and the retry in serial mode with a smaller batch size. Now that the reject file populated is having the parent external id value as blank. For this reason, my retry job loads all the contacts without the account ids for the ones that are failing where account is not present. It populates the parent external id value in the reject file if I enable Bulk API V2, but I cannot use V2 as it doesn't allow us to select the concurrency mode and batch size. Below are some of the screenshots. Any help would be appreciated.
Its a very common scenario, but I have spend more than a day with it finding the root cause.
Version used
HI,
I'm facing an issue where I can't find the snapshot option when selecting the filter pane visualization, unlike other visuals where it's readily available. Additionally, I require live data in the storytelling sheet and the ability to utilize filtered pane visuals within it.
Hello Community,
we are currently using qlik sense enterprise on windows May 2023 patch 10. when we tried to test the new extension "NL insights" in the sheets, the properties panel didn't show any contents under the "data" section to add measures and dimensions. Also weirdly, it asking for credentials for authentication. pls help us to fix this.
Note: we are using Saml SSO for the user authentication.
Whenever my laptop updates , Qlik Sense gives the following error :- Refused to Connect.
How to solve the Problem?
Kindly give the steps in detailed manner
hey !
Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do it?
Additional details:
I want to be able to load the PDF file each time I use the app.
The PDF file contains both text and a data table.
I want to be able to work with the data in the app, such as creating visualizations and performing calculations.
Please provide any relevant documentation or tutorials that I can use to learn more about this process.
Thank you in advance for your help!
Hi, I am trying to do the Num and den and accumulative, like Num = 400 and Den = 455 for 2022 Jan , its percentage is 87.9 and it is accumulating feb 88.9 and it is accumulating to 176% intead of feb 88.9 and march 89
This is my expression.
=rangesum(above(Count({<[NUMERATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))/rangesum(above(Count({<[DENOMINATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))
Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it.
For this case, I am trying to filter against a numeric field [KPI_Code]
I created a Table and inserted [KPI_Code] as a Dimension.
I have 2 expressions, the results are in the table below
Expression A: Max(KPI_Code)
Expression B: Aggr(Only({<KPI_Code={"$(=Max(KPI_Code))"}>}KPI_Code),KPI_Code)
when I use a dollar sign expansion, it always gives me the maximum number in the dataset, disregarding the dimension value.
How can I use $() and still get values just like in Expression A ???
------------
Note: I need to use the $() because I need the output value inside a variable to call its expression
Example: vKPI_$()_Expression
if the $() resulted in 1001 then the variable would become vKPI_1001_Expression and I would use it's saved expression output in the cell beside its corresponding KPI_Code
KPI_Code | Expression A | Expression B |
1004 | 1004 | |
1001 | 1001 | - |
1002 | 1002 | - |
1003 | 1003 | - |
1004 | 1004 | 1004 |
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
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!