Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Before I start:
Talend Open Studio for Data Integration v8.0.1.20211109_1610
Windows 10
Java 17.0.8.7-hotspot
jtds driver
I am trying to Guess Schema for a tDBInput (Microsoft SQL Server) component. I get the missing library dialog, but there is no way to download the missing jar file.
I have a good connection to the internet as I am able to download and install other libraries. Just this one fails. Not even sure why I am getting this dialog on v8.0 as it does not happen with v7.3.
Hi, Below is the master calander we are using and the fiscal start month is = 7.
Here I want o calculate the daynumber starting month July every year.
Datefield:
LOAD date($(varMinDate)+IterNo()-1) AS DateNum_Fisacal
AUTOGENERATE (1)
WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);
Set vFM = 7 ; // First month of fiscal year
Calendar:
Load * ,Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year
Dual(Month_F2, fMonth) as FMonth; // Dual fiscal month
Load *,Year_F2 + If(Month_F2>=$(vFM), 1, 0) as fYear, // Numeric fiscal year
Mod(Month_F2-$(vFM), 12)+1 as fMonth; // Numeric fiscal month
Load Year(DateNum_Fisacal) as Year_F2, // Your standard master calendar
Month(DateNum_Fisacal) as Month_F2,
DateNum_Fisacal
Resident Datefield;
So I have a table in my sheet in which I have amount, description and year so I want to have a column for the amount of the previous year for all the materials so that when we select any particular year the amount of the year selected and the amount of the previous year should come, how can it be done, I have tried set expressions but the desired output is not coming.
Hello
We have a Qlik CDC only task and we performed a modification on a filer transformation on a table.
We stopped that task , perform Import task with the desired modifications and perform (for mistake) resume processing of the same task.
The filer was loaded correctly (and unexpectedly !)
We remember in the past documentation that , if we have to perform a filter modification, we are aware that we will perform stop+import of the task (or perform modification by Qlik Enterprise Manager GUI and save the currently running task) and perform reload target
Can you explain us what happened ? in what case resume processing is acceptable for filter modifications scanarios ?
Lt us know
Regards
Alessandro Ferrario
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 |
I have an Application, In that a button is given to reload the data from the Sheet. Is there any possibility that the reload can be the done from the user end after publishing and giving access to the users to that dashboard.
Thanks in Advance.
Hi Community,
In which table in postgres can I find information regarding the visualization used in my app. From the table AppObjects I did get the sheet Id, but where can I find the information regrading the visualizations in the sheets.
Any help would be appreciated.
Hello,
I noticed a strange behavior according to I use a dimension or a level.
In my table, I use 2 levels and a dimension + several measures contained in a Qlik table. When I want to replace the dimension by a level, all records with 0 for current year are removed, whereas they have amounts for previous year. This is not happened when I use the dimension from the Qlik table.
3 levels:
2 levels + 1 dimension:
Do you have an idea? Is it a bug?
It is really annoying because in another column I need to calculate the difference between two measures. The loop doesn't work if I use 2 levels + 1 dimension.
Thanks for your help.
Regards,
Pauline
Hello
I need some help 😉
I have dimension AA with values 'one' and 'two'
I have another dimension BB with values 'red' and 'green'
I have several variables:
one_red = 1, one_green=2, two_red=3, two_green=4
how can I build my formula so that when looping through the table, each cell in the table is the right combination?
Pivot table:
red | green
one 1 2
two 3 4
I tried : $(=Only(AA)) & '_' & $(=Only(BB)) right but not evaluated as a varible 😞
Any help will be welcome... Thank's in advance
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!