Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Je cherche à calculer la DN (Distribution Numérique) d'une référence par rapport à son groupe d'appartenance.
Je dois donc compter le nombre de client qui n'ont pas un CA à 0€ pour ma référence ce que j'obtiens bien avec
Count({<Client = {"=Sum(CA) <> 0"}>} DISTINCT Client)
En revanche, j'ai maintenant besoin d'obtenir le nombre des clients qui ont un CA différent de 0€ pour l'ensemble des références appartenant au même groupe que ma référence sélectionnée.
Par exemple REF1, REF2, REF3 sont dans le groupe A et je veux donc savoir en sélectionnant REF1 le nombre de clients qui commandent soit REF1, soit REF2, soit REF3 donc qui commandent parmi groupe A.
Il me faudrait quelque chose comme groupe={groupe de REF1} et exclure la REF1 sélectionnée avec REF=
Je vous remercie par avance de votre aide.
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!
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
hii i made my performance dashboard in qlik sense report my data in excel . i want to update the dashboard if i change or update the data in excel i want automatacally update the dashboard in qlik sense . is it possible
Hi Team,
Today we are trying to upgrade Qliksense Multinode environment from Feb 2022 Patch 5 to Feb 2024, We follow all the backup steps which are mentioned in Qlik help-
Backing up a Qlik Sense site | Qlik Sense for administrators Help
We took backup of all certificates and Repository as mentioned in article. After taking backup we check that Postgres SQL version on Feb 2022 Patch 5 is Postgre9.6 so we decided to upgrade postgre version to postgresql14.8 which is suitable for all newer versions. For upgrading the Postgre SQL we follow all the steps mentioned in Support article as mentioned below-
Upgrading and unbundling the Qlik Sense Repository... - Qlik Community - 1934238
The PostgreSQL is upgraded successfully, after upgrading we checked the services on both Central and Rim Node all are running fine. But after that we are trying to Upgrade Qliksense, Setup started successfully but in the end it is end with an error the error is attached in screenshot.
I am not sure what problem occurs during these steps.
Please guide.
Thanks in advance
Hi! Qlikview has the ability to add new custom charts using JavaScript and it's built in API's. For example QV doesn't support population pyramid or snakey chart natively. I've used d3.js to draw these charts and it works properly. The only problem is that I don't know how to make the custom object to be able to affect the global selection of the dashboard. Selection of the native charts affects the extention but the other way around is not working. Would be happy if someone could help me.
Hello,
A bit at a loss while trying to implement a specific set of actions on a button click.
I have a table, i have some filters that can be applied. I have a button that selects just the ID after filters are selected and clear the rest of the filters. I want yet another button that does the opposite. It needs to exclude from the selected accounts from the previous selection. Using 'select exclusion' works, but for the whole table. The previous selection is overwritten.
As in the picture attached, i want to use the filters to get a subset of the 7 ids already selected. Let's say number 1 and 3. The Exclude selection button should exclude 1 and 3 and lock the final selection to 2,4,5,6,7. At the moment it returns all IDs in the table(which ar emore than 7) except 1,3.
Any advice?
Thank you!
Hi,
I have configured and setup an OIDC virtual proxy in QS QMC.
However, when my user logs on, I see that it is showing their ID instead of their name.
Why is this happening and why is it not picking up their name as it is in Entra?
Thanks
Hello everyone, i'm having issues trying to create a canonical date in qlik sense when associating tables and was wondering if anyone would be able to help out. In basic terms i have 2 tables: "orders" and "sales rep visits", which are associated to the "customer data" table by customer number, (very simplified) script below:
Customer Number | Customer Name |
1 | Cust1 |
2 | Cust2 |
3 | Cust3 |
4 | Cust4 |
5 | Cust5 |
Order Customer Number | Item | Quantity | Order Date |
3 | Apple | 4 | 2024-02-16 |
4 | Pear | 8 | 2024-02-18 |
4 | Grape | 10 | 2024-04-01 |
5 | Strawberry | 1 | 2024-03-19 |
2 | Orange | 3 | 2024-01-26 |
1 | Apple | 5 | 2024-01-02 |
1 | Orange | 5 | 2024-03-23 |
1 | Apple | 2 | 2024-04-17 |
Visit Customer Number | Visit ID | Visit Date |
3 | abc | 2024-01-21 |
1 | def | 2024-01-26 |
2 | ghi | 2024-02-02 |
4 | jkl | 2024-02-28 |
2 | mno | 2024-03-13 |
3 | pqr | 2024-03-17 |
Hi,
I have a bar chart showing sales volume per quarter (quarters on the x-axis)
currently the chart is fixed to always show the last 10 quarters, but ideally I would like to make it flexible, so that the users can select the quarters visible on their own, but when opening the sheet initially I would like to have the last 10 quarters selected automatically..
As the FYFQ field is a string like FY23-Q1, I additionally created a FYFQ_Row field which is a number count. Meaning 1 is the oldest FYFQ available and the highest number is the most recent FYFQ.
currently the chart is fixed to show always the last 10 quarters with the following dimension "if(FYFQ_Row > v_maxFYQ-10 and FYFQ_Row <= v_maxFYQ, FYFQ)" where "v_maxFYQ is defined as max(FYFQ_Row)
this works perfectly fine.
but my question is now the following:
when changing the dimension to "FYFQ" obviously the chart will show all quarters available.
I know that through Sheet Actions I can add actions that are performed on opening of the sheet, like select a specific field value, etc.
But is it possible to somehow make the selection from above dimension on sheet opening. Meaning can I automatically select the last 10 quarters in the FYFQ field on sheet opening?
Thanks for your help.
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!