Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use filter in statisticbox with sum() where pretended filter

Hi guys,

how can I use many filters to get a sum() ?

My script:

load ID, Name, City, Amount From ...

Now I want to use a statusbox, to sum the amount with specific filter like:  amount from Berlin and London; or amount from Dublin,...

with that funktion filter, I want to show the amount, that I really need.

Because I want to show many Amounts without selecting by clicking this to compare them -  like to have an overview in my statisticbox with many sums..

12 Replies
MK_QSL
MVP
MVP

Load SUM(Amount) as TOTALAMT Resident Temp

Where ID >=3 and ID <=5 Group By ID;

Not applicable
Author

CONNECT TO DB1;

Database:
Load "Posting Date",
Month("Posting Date") AS Month,
Year("Posting Date") AS Year,
Amount,
   
Description,
   
"Document No_",
   
"Entry No_",
   
"G_L Account No_",
   
"Global Dimension 1 Code",
   
"Global Dimension 2 Code",

   
SUM(Amount) as AmountGlobal where "Global Dimension 1 Code" = 'T83400' or "Global Dimension 1 Code" = 'T83500' or "G_L Account No_" <=479999 and "G_L Account No_" >=400000
;

SQL SELECT *
FROM "OBDC";

Now: I want a sum() of that expression ..

where I have to set the expression ?

1. in the load  or

2. after the SQL;  as a new table?


T1:
load "Global Dimension 1 Code", "G_L Account No_", SUM(Amount) as AmountGlobal Resident Database where "Global Dimension 1 Code" = 'T83400' or "Global Dimension 1 Code" = 'T83500' or "G_L Account No_" <=479999 and "G_L Account No_" >=400000 Group By "Global Dimension 1 Code";

MK_QSL
MVP
MVP

In the load side...