Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm developing an AR dashboard and I'm having trouble figuring out how to implement a days sales outstanding (DSO) metric for the entire company.
I'm successfully using the following expression to calculate DSO at the customer level:
sum(AMOUNT_DUE_LOCAL*Days_Past_Due)/sum(AMOUNT_DUE_LOCAL)
But when trying to use the following expression to calculate it for the entire company (while weighting a customer's total amount due relative to the entire company's amount due), I run into an error:
Sum(
aggr(
Sum(AMOUNT_DUE_LOCAL * Days_Past_Due)/Sum(AMOUNT_DUE_LOCAL), CUSTOMER_NUMBER)* Sum(AMOUNT_DUE_LOCAL))
/ Sum(TOTAL AMOUNT_DUE_LOCAL)
I've attached a simple Excel example of the desired functionality to clearly demonstrate what I'm trying to do.
Any thoughts?
Hello,
I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter
if(Gender='F','Female',if(Gender='M','Male')). it works fine.
Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.
I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')
the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.
could someone help please?
Thank you!
Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:"
Processing aborted due to error 300002:1355844283; incident 3722464.
to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;
What does this error mean?
We have a large 120M row app that we need to break up into analytics and detail. We're loading the detail as usual and in the analytics we use binary load from the analytics qvf and drop the fields. Now we need to create a bookmark on the analytics side then have a way for the detail app to use the same bookmark or at least copy the bookmark. The analytic fields are a proper subset of the detail app.
We tried ODAG last year but its interface was very cumbersome and (sorry but) the scripting requirements were even worse. The idea we're using above is very fast and requires the least amount of scripting.
We also tried document chaining by passing current selections in the detail app url but that proved to be unreliable as it worked only sometimes.
We're investigating API but not having much luck. I thought there would be something like
detailapp = qlik.app(detail guid)
detailapp.bookmark.create(name,this.currentselections,ignorelayout)
These are client-managed apps. We are not looking for a cloud solution
Hello,
As soon as I am trying to upgrade QlikSense, I have this error message display
"Value cannot be null.
Parameter name: format"
Is there a way to fix it ?
Thanks
Hi Community,
I am required to fetch the data from Odoo ERP. I have read few posts on community and some suggest trying ODBC and others Rest API, but none seem to provide a concrete solution. I want to know if anyone has actually connected to Odoo and fetched data. If yes kindly let me know how.
Thankyou in advance.
FYI :
1. I am using Odoo Online
2. I was referring to below posts
https://community.qlik.com/t5/Connectivity-Data-Prep/Reading-ODOO-data-in-Qlik/td-p/1979929
I need to multiply the value 300,000 in column 2 * the Rank(Relative). But I can't get the correct value.
What would the set analysis look like between column 2 * column 3?
Cod | Descrição do Produto | =300000.00 | Rank | Column(2) * Column(3) |
Curret |
10757 | Papel Hig Rolao 8x300 Lirios Branco | 300000 | 7,27% | 15025827000,00 | 9020,773 |
12305 | Fita Ades. Plast. 48x50 Ref.300 TRA Transp. | 300000 | 4,10% | 8461812000,00 | 63619,31 |
13248 | Arquivo Morto Pap. Ond. Compacto Ref.1170 Marrom | 300000 | 3,01% | 6213060000,00 | 12285,75 |
13697 | Papel Hig Rolao 8x300 Lirios 100%Cel | 300000 | 11,97% | 24739770000,00 | 14068,45 |
16923 | Seven Denso Desengraxante Plus 1:100 5Lt Ref.5260 | 300000 | 6,23% | 12882420000,00 | 4802,176 |
17459 | Papel Sulf. A4 75g/m² 500Fls Branco Chamex | 300000 | 24,93% | 51509256000,00 | 35919,8 |
19201 | Papel Toalha Bob 8x100m Bromelia 100%Cel | 300000 | 5,18% | 10710954000,00 | 21816,07 |
19303 | Papel Hig Rolao 8x500 Lirios 100%Cel | 300000 | 6,45% | 13334085000,00 | 19359,82 |
2061 | Lápis Dermatográfico Ref.7600 Branco Mitsubishi | 300000 | 4,69% | 9689652000,00 | 74786,54 |
29976 | Luva Nitríl. s/Pó c/100Un PQ Talge Ref.7240 Azul | 300000 | 1,60% | 3307500000,00 | 15551,29 |
5277 | Copo Desc. 180ml c/100Un Branco Copobras | 300000 | 21,21% | 43817820000,00 | 10065,97 |
5543 | Pincel Marc. p/Retrop. 2.0 Azul Pilot | 300000 | 3,36% | 6932937000,00 | 18704,05 |
Sys overview:
# Windows Server 2022 Standard
# QS Enterprise on Windows - February 2024 and November 2023 (initiall releases)
This is what I get.
screen
I've attached the log from PostgreSQL 14:
# it seems that PostgreSQL 12.5 is installed fine
#... but PostgreSQL 14 failed for some reason ...
any ideas ?
I know this girl since 2019 from a part time job i did on and off. Her name is Sarah and she has the most beautiful smile I have ever seen in my life. I always like talking to her but she sees me nothing more than a friend. And of cause 2020 happened so I didn't have any communication with her until 2023 when I met her. She a insurance agent now and I got closer to her by getting some life insurance and investment plans with her.
Her birthday was recently on 5 April and I got her a jungkook(BTS) funko pop as she really loves BTS like crazy.
We sometimes head over to Johor Bahru once in a while for shopping and food. This gets me to meet her more often but I don't want to ruin this moment by telling that I love her and having my only chance to meet her gone. But I also don't want to wait too long until some other guy takes this chance to get her. I don't know how much will it help me by putting out my story here but I can't lock it in my heart for too long as it's hurting me. So I had to let is out here.
Hi Team,
I have this below code to get the task list from QEM.
# Define the URL for the API call
$url = "https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/tasks"
# Prepare the headers for the API call, specifically the session ID
$headers = @{
"EnterpriseManager.APISessionID" = "wCo0_KvjEUFROvfHF5KGrw"
}
# Make the HTTP GET request and ignore SSL certificate validation errors
try {
$response = Invoke-WebRequest -Uri $url -Headers $headers -Method Get -SkipCertificateCheck
# Check if the request was successful (status code 200)
if ($response.StatusCode -eq 200) {
Write-Output "Tasks retrieved successfully:"
Write-Output $response.Content # Print the response content which includes the task list
} else {
Write-Output "Failed to retrieve tasks, status code: $($response.StatusCode)"
}
} catch {
Write-Output "An error occurred: $_"
}
how to find Session ID of QEM? Pls suggest.. Also I need last week task list using the same.
thanks
Vish123
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!