Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
present in my dashboard group values are displaying like below single group name to each master number, but is there any way to combine these values like for example attached both tables, can anyone please help.
Present format:
Master Number |
Master Name | Location | Client | Classification | Group |
1137 | EXOR | Italy | South PRD | Diamond | Automotive |
1137 | EXOR | Italy | South PRD | Diamond | Comms & Media |
1137 | EXOR | Italy | South PRD | Diamond | Utilities |
1137 | EXOR | India | South PRD | Diamond | Automotive |
1137 | EXOR | India | South PRD | Diamond | Utilities |
Required Formate:
Master Number | Master Name | Location | Client | Classification | Group |
1137 | EXOR | Italy | South PRD | Diamond | Automotive,Comms & media,Utilities |
1137 | EXOR | Italy | South PRD | Diamond | Automotive,Comms & media,Utilities |
1137 | EXOR | Italy | South PRD | Diamond | Automotive,Comms & media,Utilities |
1137 | EXOR | India | South PRD | Diamond | Automotive,Comms & media,Utilities |
1137 | EXOR | India | South PRD | Diamond | Automotive,Comms & media,Utilities |
I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.
I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.
Load
count(if(status='Current',"EmpName")) as JanExisting,
count(if(status='Current',"EmpName"))
+count(if(status='New' and Month='Jan',"EmpName")) -
count(if(status='Exit' and Month='Jan',"EmpName"))
as JanFinal
Resident MyTable;
Load
JanFinal +
count(if(status='New' and Month='Feb', "EmpName", null())) -
count(if(status='Exit' and Month='Feb', "EmpName", null()))
as FebFinal
Resident MyTable;
Load
FebFinal +
count(if(status='New' and Month='Mar', "EmpName", null())) -
count(if(status='Exit' and Month='Mar', "EmpName", null()))
as MarFinal
Resident MyTable;
I need to retrieve data from .xlsb files located on SharePoint and also to read all existing sheets names from normal .xlsx files located there. I assume in both cases ODBC connection via Microsoft Excel driver could work for me, but not sure how to set up the connection.
I tried to create connection string based on SharePoint link, based on links to local files, also tried to connect to attached files - no results (different error messages with lack of info what is wrong).
Could you help me please with typical connection string and other parameters to get connected to xlsx or xlsb files?
(Qlik Sense SaaS, Microsoft Excel Driver installed on the server)
Hi veryone,
is it possible to use a formula in a pivot table which was loaded from database?
I've loaded a table from our database which looks like that
those formulas work if I use them directly in my pivot table, but not if use the field which stores the formulas,
I'm ending with something like that
Within the pivot table I've several If-Statements like
if(SPALTEBVBEZEICHNUNG='Vorjahr',
if(SPALTEBVID=1,KENNZAHL_KONTAKTE_VJ,
...
where KENNZAHL_KONTAKTE_VJ is one of my fields storing a formula.
I've tried to write it like '$(=KENNZAHL_KONTAKTE_VJ)' or =$(=KENNZAHL_KONTAKTE_VJ) but i just don't get it.
Maybe someone has a hint for me?
Thanks!
Markus
Hi Friends,
I got a requirement that is Categories the types of Incidents from ServiceNow data.
Our source data from ServiceNow, every day we will load data from ServiceNow to Qlik sense. Actually the data flow is ServiceNow >> Gsheet >> Qliksense.
Actually the requirement is in the below:
Please find the below sample incident data which was raised by users with different short descriptions.
Incident_number | Short Description | Created By | Open Date | Due Date | State |
INC001 | Unable to access XYZ stream, please provide access | ABC | 3/27/2024 | 4/1/2024 | Open |
INC002 | Got error message like 'Access Denied' while accessing the ABC dashboard URL link | CDE | 3/26/2024 | 4/1/2024 | Open |
INC003 | I am unable to access the folder | FGH | 3/25/2024 | 4/1/2024 | Open |
INC004 | I am unable to sign in Workday portal | IJK | 3/24/2024 | 4/1/2024 | Open |
INC005 | Can you grand me access to the database | LMN | 3/23/2024 | 4/1/2024 | Open |
INC006 | Batch job failed to run | OPQ | 3/22/2024 | 4/1/2024 | Open |
INC007 | XYZ Dashboard qmc task aborted | RST | 3/21/2024 | 4/1/2024 | Open |
INC008 | Failed - Informatica xyz_inflow task incomplete | UVW | 3/20/2024 | 4/1/2024 | Open |
Here row number from 1 to 5 should fall under "Access Related Issue" category and row number from 6 to 8 should fall under "Batch Job Related Issue".
Category | Count of Incidents |
Access Related Issue | 5 |
Batch Job Related Issue | 3 |
How can we achieve this. Can you please help me this.
Appreciate your help and thanks in advance.
Hi Team,
Please refer below details i need the help to count only positive value excluding 0. in total i need to need count of if can anybody help me on this.
Distributor Name | Sub Dealer Name | YTD-2024 | label_1 |
A | AA | 1 | 1 |
B | AA | -1 | 0 |
C | Bc | 2 | 2 |
D | BD | -1 | 1 |
E | SD | -1 | 1 |
F | FE | -1 | 1 |
Total | -1 | 6 |
Hi,
I am using a Qlik Sense dashboard (it is currently being hosed in cloud) with JWT authentication and Section Access.
I am able to open up the dashboard from my web application as a separate page, but I'd like to open it up in an iframe.
Has anyone implemented this?
Thanks.
Hi, I am creating a chart with multiple lines to indicate a base price, a price that gets 50% of the calls and a line indicating a price that gets 100% of calls.
The 3 boxes to the right indicate where the lines should be. The red line and the green line are functioning correctly but the yellow line should be at 35 and is instead fixed at 0.
To calculate the yellow line I am using this calculation:
round(fractile(total_revenue, 0.5)*1.2 , 5)
The reason I think there might be an issue here is because the green line uses almost the same calculation, but shows the correct answer.
round(fractile(total_revenue, 1.0)*1.2 , 5)
Below are screenshots of how the lines are showing up on the bar chart. The green line and red line are correct the but the yellow line is not at the 35 mark even though for the box and the yellow line I have just put the same calculation. I have tried adjusting the fractile value for the calculation and there still mismatch for the yellow line. I also tried deleting and recreating the master item with the calculation, deleting and recreating the line, deleting and recreating the box and just adding the calculation to the box and the chart without the master item.
Does anyone have any idea what could be wrong here?
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
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!