Hello.

I am creating an app, using three qvd files.

my script is:

LOAD
    %0MATERIAL,
    %0MAT_SALES
FROM [1.qvd]
(qvd);

Load
    %0MATERIAL,
    "Corporate Reporting Group (Material)"
FROM [2.qvd]
(qvd);

LOAD
    %0MAT_SALES,
     "Local product hierarchy 2",
FROM [3.qvd]
(qvd);

I need a field, which would be a combination of  "Corporate Reporting Group (Material)" and  "Local product hierarchy 2"

I understand I need to write something like "Corporate Reporting Group (Material)"&' '&"Local product hierarchy 2" as NewField, but where and how exactly?

Thank you very much in advance

I have outer join 2 tables one as current period and one as last period.  After joining, I need to do calculation using the joined data.  May I know how I do it in script?

I have invalid expression in the below script:

[FTP]:
LOAD
Period,
"Ip Shrt Name Ith",
"Arr Lcl Num Ath",
"Global Sic Code" as t0_SicCode,
"Month, Day, Year of Glbl Trade Date" as t0_TradeDate,
"Month, Day, Year of Maturity Date" as t0_Maturity,
"Credit Grade Code" as t0_CRR,
amt as t0_Amt
FROM [lib://Loan/QS test1.xlsx]
(ooxml, embedded labels, table is Sheet1);

Outer join

LOAD
"Arr Lcl Num Ath",
Period as t1_period,
"Ip Shrt Name Ith",
"Global Sic Code" as t1_SicCode,
"Month, Day, Year of Glbl Trade Date" as t1_TradeDate,
"Month, Day, Year of Maturity Date" as T1_maturity,
"Credit Grade Code" as t1_CRR,
amt as t1_Amt

FROM [lib://Loan/QS test2.xlsx]
(ooxml, embedded labels, table is Sheet1);

[New]:
Load*,

sum(t1_Amt) - sum(t0_Amt) as Var

Resident [FTP] group by "Arr Lcl Num Ath";


Drop Table [FTP];

Hi:

I'm new to Qlik Sense, and I am trying to learn from the Tutorials: https://help.qlik.com/en-US/sense/November2020/tutorials/Tutorial%20-%20Building%20an%20App.zip

I asking myself how I could know related items by Invoice. The idea es know which items people buy together.

If I use SQL I can try a Self Join for Sales table. 

I googled for "Self Join Qlik" and It seems there is no natural way to do that. 

Maybe there is a natural way to do what I want, but it's not through a self join. 

Any ideas?

I cannot expand the Formulas in a pivot table.

I made a Load Inline to create this two dimensions, here is the code:

Valores_Financeiro:
LOAD * INLINE [
'Tipo Valor', 'Medida', 'Fórmula Financeiro'
'Receita', 'Descontos Obtidos', "vReceitas Descontos Obtidos"
'Receita', 'Juros Auferidos', 'vReceitasJurosAuferidos'
'Receita', 'Outras Receitas Financeiras', 'vReceitasOutrasReceitasFinanceiras'
'Receita', 'Ganhos Oper. Renda Variável', 'vReceitasRendaVariavel'
'Receita', 'Variações Monetárias Ativas' , 'vReceitasVariacoesMonetarias'
'Receita', 'Variações Cambiais', 'vReceitasVariacoesCambiais'
'Receita', 'Outras Receitas Operacionais', 'vReceitasOutrasReceitasOperacionais'
'Despesa', 'Bancárias'
'Despesa', 'Monetárias Passivas'
'Despesa', 'Arredondamento Mercantil'
'Despesa', 'Juros Pagos'
'Despesa', 'Bancárias Exportação'
'Despesa', 'Variações Cambiais'
'Despesa', 'Perda Renda Variável'
];

Here is what happens:

 I need to expand the formulas, thought it was just put $([Fórmula Financeiro]) in measures but it doesn't work.

With ValueList i can make this work but than if you select it doesn't select in the right way than for me it doesn't work, i need in this way because than the user can select and then it will filter.

Obs: this variables contains the formulas

Example: vReceitasDescontosObtidos contains Sum([Receitas Descontos Obtidos]/1000)

hi team,

I am using the below expression in a line chart. I get the trend line if I select only one channel, however if i select multiple channels, the chart is simply blank. pl help me solve this.

if(Channel='AMS',Sum({$<Variables={"ams_direct_cost"}>}Values),
if(Channel='GCM',Sum({$<Variables={"gcm_direct_cost"}>}Values),
if(Channel='FB',Sum({$<Variables={"fb_direct_cost"}>}Values),
if(Channel='ISG',Sum({$<Variables={"isg_direct_cost"}>}Values)))))

regards, mahe

Hello all, 

I am fairly new to Qlik, and I am attempting to assign and display a Sales Group designation for each ID in my Purchasers table.  My tables look something like this and are imported via flat file: 

Purchasers:

CustomerID    Name       Region

1                           John           A

2                           Jane           G

3                           Jacob         X

.

.

.

Transactions:

TransactionID      CustomerID            Name            Amount

1                                           2                        Jane                  40

2                                           1                        Jacob              100

3                                          2                          Jane                  20

4                                           2                         Jane                  10

.

.

.

In the data load editor, I want to create a column that assigns a group to each CustomerID based on definitions created using IF THEN ELSEIF statements in the Purchasers table.  I use the Transactions table to append some calculated transaction summaries to the Purchasers table (which works), and I need to use those calculated columns for the sGroup classification as well.  When I am done with the Transaction table summaries, I am dropping the Transactions table.  This is similar to what I have so far:

Load * From Purchasers;

Load * From Transactions;

---script that does transaction calculations per purchaser, columns are now loaded to Purchasers table---

DROP TABLE Transactions;

FOR EACH x in FieldValueList('CustomerID')
LET sGroup=Null(); 

IF Region='A' AND sTotal>50 THEN
LET sGroup=010;
Concatenate
GROUP:
LOAD x AS [CustomerID], sGroup AS [Sales Group];

ELSEIF Region='B'  AND sTotal > 50 THEN
LET sGroup= 020;

Concatenate
GROUP:
LOAD x AS [CustomerID], sGroup AS [Sales Group];
.

.

.

ELSEIF Region='AA' AND sAvg>100 THEN 

LET sGroup= 270;

Concatenate
GROUP:
LOAD x AS [CustomerID], sGroup AS [Sales Group];

ELSE
ENDIF
NEXT ID

All of the other community posts I have found are resorting back to nested if statements in the initial table load, but I have so many different groups that need to be assigned and my definitions are also based on other calculations from the Transactions table.  I have written something similar in SQL using the CASE statement, and the IF THEN ELSEIF seems to be Qlik's closest match to that.  The script loads just fine, but I do not see the Sales Group column in my final Purchasers table.  I am not sure if I need to create this GROUP temp table to concatenate/left join to my Purchasers table or if there is a way to INLINE this sGroup value (which is fixed for the logic definitions) into the Purchasers table for the current CustomerID that the For Each Loop is currently evaluating. 

Any help would be greatly appreciated!  Thank you in advance!!! 

I would like to ensure my pivot table exclude [name] where

[t0 CRR]=[t1 CRR] and

[t0 impr stg] = [t1 impr stg] (row in Red font).

I have tried to use below set analysis in Dimension but it does not work.  The result returns one null row.  

Would need guidance from experts again.  Many thanks as always.

=aggr(only({<[t1 CRR]-=[t0 CRR]>,[t1 Impr Stg]-=[t0 Impr Stg]}[name]),[name])