Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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...