Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, I have DB2 data source and we implemented Qlik replicate. Now DB team is asking for enable audit trail they want to know is any impact will come on Qlik replicate.
We have the following questions.
1. whether it can be deployed on ubuntu servers to schedule tasks on a regular basis.
2. Is it possible to have an interface to view the execution process of each node for the executed tasks?
3. if there is an error on a node, does it support re-execution from the error node?
I am new to Qlik and i am testing for section access. In my sheet (for testing purposes), I want to display the email of the user who is looking at the sheet. Basically, i want to show the users email id (which is defined in section access) on a text&image object in the qlik sheet.
Hi,
I'm wondering about a certain scenario.
Say for example, there is a large table that needs to go to an ADLS target using parallel load, and there are 5 parallel segments.
Is there a possibility of say segment 4 loading before segment 3? Thus resulting in incorrect sequence in ADLS.
Also, are there any best practices regarding loading very large static tables to ADLS? My only current idea is parallel load. Thank you
Regards,
Mohammed
Mohammed
Greetings.
Is it possible to split data on the load coming in from excel in a single column (InputField) into multiple columns using the blank rows between questions as a delimiter?
Current...
InputField | |
____ Yes, we use this practice today |
|
____ No, we have a different practice in place | |
2. Question2? | |
____ Yes, they can do this independently in all scenarios | |
____ Yes, they can do this independently in some scenarios | |
3. xxxxxx |
Desired...
newcolumn1 | newcolumn2 |
Question1 ____ Yes, we use this practice today ____ No, we have a different practice in place |
Question2 ____ Yes, they can do this independently in all scenarios ____ Yes, they can do this independently in some scenarios |
|
Hi All,
I have sheet and i want to add images as sheet background. there is no option in sheet properties in my current version in my organization.
I am trying to add using html and css but it's not working properly.
.qv-panel-sheet {
background-image: url("C:\Users\Desktop\1600w--kbTNqEWceg.png");
}
Can you please suggest me how to do this scenario in Qliksense.
Thanks & Regards,
Lakshman
Hi,
I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis.
The differences is that in the balance sheet you have an ingoing balance and then the changes during the month is booked and then you get an outgoing balance, in my dataset there is no ingoing balances available from the database from any tables that I've found.
I want to to a rolling 12 months analysis on inventory turnover rate and need to be able to calculate averages for a twelve months period every month ending to get this KPI.
I've added the ingoing balance for 2021-05-01 manually and concatenated with the transaction data, from this I can get an outgoing balance every month with RangeSum and Above where I've set period of times to 100000, (maybe there is a smarter way) which gives me the outgoing balance every month.
RangeSum(Above(Sum({<Sub_Group={'Inventory'}>}Amount),0,100000),)
How do I use this? I need to bring the value from 2021-05-01 to 2024-03-31 for example to be able to get my outgoing balance for 2024-03-31, see example below.
Is there a way to make a calculated field instead to use in set analysis or any other way that is more simple just shoot with ideas!
Help much appreciated, thanks!
Buen día comunidad
Requiero ayuda con lo siguiente, tengo dos tablas:
Historico: con el campo ID:[1,2,3,4,5]
Mes: ID[1,2,6,7,8]
No he podido hallar la forma de cruzar las dos tablas para obtener los registros no coincidentes, lo que deseo es saber mediante un script los registros de la tabla del Mes que no están en el Histórico
I have a map below, which related food to fcode. fcode is the key that links multiple tables together.
map1:
[food,fcode
apple,a
apple-pie,a
banana,b
banana-float,b
cherry,c
cherry-coke,c];
Let's say
Table 1 -uses fruits (applymap() can be used to turn food into fcode)
Table 2 -uses fcode (can not reverse into food)
Table 3 -uses fcode (can not reverse into food)
How can i create a filter, such that:
1. the filter display the food values. (i.e apple-pie and not 'a')
2. When selecting food values, the filter is applied to all tables (1,2,3). I.e if I select apple-pie (or apple), the filter also set fcode to 'a' and table 2,3 will display only information relating to 'a'. Note that it is accepted for either apple-pie or apple to be selected to filter for fcode 'a'
If I use applymap() on table 1, and filter by fcode, i lose context for my users who only understands food.
Can we create custom banner in Qlik Saas.
We have to display message on Hub if there is any planned maintenance or data refresh failure.
This facility is available in Enterprise version. But didn't find on qlik SaaS.
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!