|
Expression
|
Meaning
|
|
sum(revenue)
sum({$} revenue)
|
Revenue
in current selection. sum of the current selection (= sum([revenue])
|
|
sum({1} revenue})
sum({1}
Total revenue})
|
Revenue
disregarding the selection or disregarding selection and
dimension. sum of everything (All dimensions are completely reset to All)
|
|
sum({$<revenueDate
= “12 Jan 2015”>} revenue)
|
Revenue
in current selection for a specific date
|
|
sum({1<Country
= {US}>} revenue)
sum({1<Country
= {“US”}>} revenue)
sum({1<Country
= {‘US’}>} revenue)
sum({1<Country
= {[US]}>} revenue)
|
total revenue
for country=US
|
|
sum({<Country
= >} revenue)
|
Revenue
in selection with country removed (idem $)
|
|
sum({<Country
= {“*”}>} revenue)
sum({<Year
= {*}>} revenue)
|
Revenue
in selection with country removed (idem $)
({*} for
numeric, {"*"} for text
For All
Country
|
BI tips and tricks with qlikview, Set Analysis, Qvds, Script, Expressions, Charts, Dimentions, various properties, Analysis
Friday, June 12, 2015
Set Analysis-III
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment