Hello guys.
I want to make a graph where I have a dates, each one represents the end of month, and a measures the situation of the portfolio (accounts receivable) and on the other hand the sales.
Accounts receivable is at the end of the month, since I cannot accumulate these values daily because it would create a distortion, while sales need to be accumulated each month so that it reflects the data and metrics that I need to present. How can I make the graph?
Thanks for your time and help.
Hi, I'm doing some test with Qlik Cloud Data Integration.
I want to know how to reload specifig table (or all tables ) in Onbording task.
there are no descriptions about this operation in the product document...
Best Regards,
Keishi Miyachi
Hi,
I'm trying with the SAP admin to use the SAP HANA (database) connector but get an error when I want to get the tables. Database is 2.0, multi-tenant but used as single with SAP Business One.
With the specific created user we dont get a succesful connection with the TEST button. If we use the SYSTEM user then the connection is succesful. The problem occur when we want onboard data and Qlik is searching for tables. This error message will appear. Please note: gateway is connected.
Service returned unsuccessful status code 'NotFound' on 'GET' at '/v1/replicate-agents/$
It looks like if the permission level isn't right. The SAP admin gave all database roles to the SYSTEM use and SELECT & TRIGGER on schema. Still same problem. We can not open database file.
I raised already a ticket at Qlik support. But maybe a SAP expert see this thread also. Both I and the SAP admin does not know what to do anymore.
Does somebody has a clue?
Thank you!
Hi
I had to switch accounts for work reasons, is it possible to move the history of my old community account to this new one? my previous one is User ID 70848.
@Anonymous @itsupport
Thanx
Roberto
I am preparing QSBA. Found some old exam questions from different sources but provided questions do not seem always right. Appreciate if any one can shed some lights
1. A business analyst creates an app for a large retailer. The app is based on me past 2 months of transactional data in CSV form. After successfully demonstrating the app, the retailer provides a big file that contains another seven years of data
After the new data is loaded. The previously responsive app takes 10 times longer to respond to users' selections. The app has many complex expressions
Which two actions should the business analyst take to resolve the issues? (Select two)
2
I thought this is a no brainer of B, but it says A is the correct answer.
I guess A could remove some of outliers but 2 interquartile ranges wont' be sufficient to remove the outlier far way from
major whiskey bar, right? or am I reading this question at a wrong way?
3.
To improve efficiencies a hospital mustanalyze how often a surgery is started late by operating room and surgeon.
The business analyst must consider several factors
• Dates of each surgery
• Number of minutes the start of the surgery is delayed
• Operating room
• Surgeon name
Which visualization should the business analyst use to meet these requirements?
I go for B, but answer is D ...no idea why it is line chart
4. After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.
What should be developed to meet this requirement?
given by it is over 12 month period, I feel like this should be B...but why it is D...there is no contribution to show at all
5.
CEO wants to review total sales in terms of cost and gross profit, if you could only use one viz tool to represent it. which one is the best.
scat plot, bar, waterfall, KPI
should it be waterfall? I mean , cost and gross profit is one negative and one positive, waterfall could be better than bar.
what you think?
This not working
sum({<QC_EvaluationResult>} MonthYear)
And I must show on label colum MonthYear and I is possible choose dimension panel MonthYear or Year
Creating a snapshot for our database and using RUN_DATE as the date in which each database run is completed. I need to sum values based on max date -1 (previous day totals)
Currently WORKING Max Date Sum:
Sum( {<RUN_DATE={'$(=Max(RUN_DATE))'}>} RECORD_COUNT)
How can I run the previous days totals? I'm used to seeing something like date(max(RUN_DATE)-1)
I would like to increase the actual years in my Calendar by two years. The actual first and last years in the date field of the Order table, on which the current Calendar is based, are 2010 and 2021 respectively. The script would change these years to 2012 and 2023 respectively. I have tried AddYears in the Calendar script, but this does not work.
Thanks in advance for any help!
Here is my Calendar script (note that I have commented attempts below to make this work using the AddYears function):
DateRange:
LOAD
min(Date) as MinDate,
max(Date) as MaxDate
// AddYears(min(Date, 2) as MinDate,---> did not work
// AddYears(max(Date, 2)) as MaxDate,---> did not work
// Min(AddYears(Date, 2)) as MinDate,---> did not work
// Max(AddYears(Date, 2)) as MaxDate,---> did not work
Resident POS;
LET vMinDate = Peek('MinDate',0,'DateRange');
LET vMaxDate = Peek('MaxDate',0,'DateRange');
TempCalDate:
LOAD
date($(vMinDate) + RowNo() -1) as CalDate
AutoGenerate $(vMaxDate) - $(vMinDate) + 1;
Calendar:
LOAD
CalDate as Date,
day(CalDate) as Day,
WeekDay(CalDate) as WeekDay,
Year(CalDate) as Year,
Month(CalDate) as Month,
week(CalDate) as Week,
'Q' & Ceil(month(CalDate)/3) as Quarter,
4*Year(Today())+Ceil(Month(Today())/3)-4*Year(1)-Ceil(Month(1)/3) AS [QuartersAgo],
date(monthstart(CalDate), 'MMM-YYYY') as MonthYear,
date(QuarterStart(CalDate), 'QQ-YYYY') as QuarterYear
Resident TempCalDate
order by CalDate asc;
drop Tables DateRange, TempCalDate;
Qlik Staige, an all-encompassing solution that provides the technology, ecosystem, and expertise you need to bring better insights to your business, faster.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on Sept. 27th at 10 AM ET for the next Do More with Qlik session, where we will be featuring Insight Advisor – our intelligent AI-assistant in Qlik Sense.
Real-time Responses Delight Burgan Bank's Customers.
Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.
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!