Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
Hi,
If the developer forgets to check the "initial data reduction based on section access" button under Document Properties - the Section access in the script is not in affective. no data reduction is done.
We have more than 200 models, how can I verify that the developer remembered to check it?
how can I get an indication/report that the "initial data reduction based on section access" is checked (except from opening 200 models and see if it is checked)?
Thanks, Elad.
Seems like I misunderstood how the Set Modifier is meant to work. Would appreciate if someone can clear things up for me. I'm attaching a sample application which I'm working from. In the application is a simple data model with a table for games, a table for invites, and a table for participant.
What I'm trying to count is the number of times a person has chosen to ignore their invite and not participate in the game in a table format where the dimension is the person. Should be pretty simple.
The number of games they have been invited to is : sum({<NumInvites = {1}>} NumGames)
The number of games they participated in is : sum({<NumParticipations = {1}>}NumGames)
Shouldn't the number of games they chose not to participate in be the difference between the two sets?
=Sum({
<NumInvites= {1}> -
<NumParticipations = {1}>
} NumGames)
And, yes, I know I can change the logic to
sum({<NumInvites = {1}>} NumGames) - sum({<NumParticipations = {1}>}NumGames)
but I want to understand why the difference in SetModifiers does not work.
Hello,
I am trying to develop a chart extension. I created a dropdown in the extension properties field. I want to make multiple selections from the data listed in the dropdown. Do you have a solution?
I have a situation where I want a measure, like a weekly average for the dimension value to the dimension values in a pivot table. For example in the below I would like the overall average next to the state before the measure values by month.
Something more like this
Thanks in advance.
I have the below field in the database, where I need to create a pie chart with with DATA vs DOMAIN
1|DATA|-|Def|-
3|DATA|-|dafsdf|-
4|DATA|-|sdfr|-
7|DATA|-|fwef|-
6|ABD|DOMAIN|-||-
9|EFDS|Other||-|-
The chart should reads from the abobe table (Sample) to differentiate with and display the below result (data vs domain) as
DATA as 66%
DOMAIN as 17%
and Other should name as NA in 17%
Hi team,
I have filter, In that i have some values.
Eg:
A
B
C
D
if I select A and B its to display sum(Sales)
If I select A and B and C etc its to display count(Sales)
For Particular Selection, I need to show one measure,
If extra anyone Value is added in the filter it should show other measure...
Thanks in Advance
Hello,
I have this load script for one of my app in Qliksense.
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LastName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.
User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LasrName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
WHERE Fiscal_Year >= (YEAR(GETDATE())-2); //to get only year 2024 and 2023,2022//
It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021
I am not sure what I am missing. Could someone please help me with this?
thank you!
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!