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 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?

•  A.A combo chart that shows total minutes of delayed starts by operating room and surgeon
•  B.A bar chart with total minutes of delayed starts and a drill-down from operating room to surgeon
•  C.A scatter plot with delayed start minutes per day operating room and surgeon
•  D.A line chart with total minutes of delayed starts and a drill-down from operating room to surgeon

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?

•  A.Grid chart with diverging color by measure
•  B.Line chart with area gradient color by measure
•  C.Waterfall chart with custom positive value color
•  D.Mekko chart with diverging color by dimension

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;