Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,
I was checking if we could install NPrinting, Alerting and Geo Analytics on the same server. couldnt find any articles related to it. I know that Qlik doesnt support QS and NP on a same server but not sure of NP and Qlik Alerting on the same server.
Thanks in Advance
Qlik NPrinting Qlik Alerting Qlik GeoAnalytics
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.
Hello ,
I am trying to develop a graphic extension. I created a button in the extension properties field. When I click on the button, I want to add the dropdowns that already exist . For example, when I press the dateDropdown button, it should be added to the properties field again.However, it does not make this addition with the code below. Do you have a solution? Thank you.
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.
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!