Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Iam totally fresh to functions .
THANKS for ur Reply Guys
Actually i have dimensions called BRAND which has many different brands and under each brand ther are many branches depending on the cities , so my teacher asked me to write such an expression when i clikc on perticular branch type , it should show to which brand and which city it is belonged , I HOPE SO IAM CLEAR
Thanks in advance
This may be a good place for you to start
this is an example:
Sum({$ <brand={'Ferrari'}, brand_type={'CAR'}, city={'NEW YORK'}, customers={'DUFFY'}>} Sales)
let me know
What are you trying to accomplish with your selection?
The default set analysis is the current selection.
Examples:
sum( {$} Sales )
returns sales for the current selection, i.e. the same as sum(Sales).
sum( {$1} Sales )
returns sales for the previous selection.
sum( {$_2} Sales )
returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two Back operations.
sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as
dimension, each product will get a different value.
sum( {1} Total Sales )
returns total sales within the application, disregarding both selection and dimension. I.e. the same as sum(All Sales).
sum( {BM01} Sales )
returns sales for the bookmark BM01.
sum( {MyBookMark} Sales )
returns sales for the bookmark MyBookMark.
sum({Server\BM01} Sales)
returns the sales for the server bookmark BM01.
sum({Document\MyBookmark}Sales)
returns the sales for the document bookmark MyBookmark.
These examples are from the QV help files.
Hi start with this.
Regards
ASHFAQ
Check this