Welcome to Qlik Community

Ola a Todos, espero que estejam Bem!

Estou tendo problemas ao consultar planilhas  no Qlick sense

ocorre que eu consigo executar a query (View) pelo desktop ao banco de dados interno da empresa. 

contudo,  pelo Saas, conecta mas não consigo executar a query (View) ao banco de dados da nuvem.

ocorre o seguinte erro :

(Connector error: ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function)

alguém consegue me explicar o por quê?

abraços,

Felipe Oliveira

Hello Qlik community !! 

I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount. 

My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity  "Company" based on the Sum of the total amount, whether they acted as buyer or seller. 

For example supposing I have this values in my Table:

I want a table-chart that displays: 

Will really appreciate it if someone can help me 🙂

Hi,

I have gone through the concept of NOT Exists but it is throwing me off. Please help me in understanding how does NOT EXISTS work in the script. 

Below is the pseudo-code I found on internet and I tried executing this code in QS . The result doesn't make  sense to me. 

First:
Load F1 As F1Reduce, F2;
LOAD * INLINE [
F1, F2
1, North
2, South
];

Concatenate(First)
LOAD * INLINE [
F1, F2
1, North
2, South
3, West
4, East
3, West1
4, East1
]
where not Exists(F1Reduce,F1); //Loads records where F1's value not present in Table : First

drop Field F1Reduce from First;

The output I get is 

I am not expecting the above output. What I am expecting is East, East1, West , West 1. How do I modify the script?

My lack of understanding of NOT Exists is not helping me. 

Hello Qlik community !! 

I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount. 

My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity  "Company" based on the Sum of the total amount, whether they acted as buyer or seller. 

For example supposing I have this values in my Table:

Table:

[ Date, Buyer, Seller, Total Amount 

  12/05/2020, Apple, Amazon, 2000

  13/05/2019, Amazon, Apple 2500

  01/01/2020, Apple, Microsoft, 1000

]

I want a table-chart that displays: (Rank, Company, TotalAmountTransactioned)

1 - Apple - 5500

2 - Amazon - 4500

3 - Microsoft -1000

Will really appreciate it if someone can help me 🙂

I was upgrading from a Qlik Sense Free Trial to Paid version. I recieved a welcome email that needed to be activated...once activated an error message "You have met the allowable number of tenants you can create. To manage your license, contact Qlik Sales." is there any way to resolve this today without waiting for someone from sales to get back to me tomorrow? 

Hello,

I have an exercise to perform which consists in creating a personalized map in order to add heat points according to the zones impacted by an indicator. To facilitate the work, I cut the map into 6 zones.

Do you know if it is possible to do this with Qliksense please? If so, how please?

thank you

HELO

Hi

PFA

I am trying to extract a list of distinct Tablenames into a delimited string, and I'm not getting it right.

I'm thinking I could probably use the current For..Next ("For Count...")loop to get this, and not to have another resident load.

In fact, I would need to do exactly the same for the field REQ_DATE and REQ_HOUR (long story..... 🙂

Please may you have a look - here is my model.

Thanks

Hi All

Below is the load script :-

Accounts_001:
LOAD * INLINE [
DocNum,TotalSumSy,Customer_Name
1,3,SERVO ENGINEERING SDN BHD
1,3,SERVO ENGINEERING SDN BHD
2,5,SERVO DYNAMICS SDN BHD
];

For Each i in 501
WhatIfDimension$(i):
LOAD * INLINE [
Pls select $(i)st Dim,Column$(i)
SOURCE,SOURCE
SQ_Num,DocNum
Total,Total
Customer_Name,Customer_Name
];
NEXT i;

My Table Dimension :-

=$(ColumnDim501)

My Table expression :-

=pick(Match([Pls select 61st Dim],
'Ave_SQ_Amt',
'Total_SQ',
'Total_Amount',
),
sum($(ColumnDim61))/count(DISTINCT $(ColumnDim61)),
count(DISTINCT $(ColumnDim61)),
sum($(ColumnDim61))
)

Total Amount = 12 is correct :-

Total number of Quotation = 2 is correct :-

Base on above Total =12 And No of Quotation = 2 Average = 12/2=6 , But my result shown = 4 which is wrong :-

Hope some one can advise me.

Paul Yeo