SET ANALYSIS

[#1]

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

[#2]

This may be a good place for you to start

Set Analysis: syntaxes, examples

[alexandros17]

this is an example:

Sum({$ <brand={'Ferrari'}, brand_type={'CAR'}, city={'NEW YORK'}, customers={'DUFFY'}>} Sales)

let me know

[#4]

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.

[ashfaq_haseeb]

Hi start with this.

Regards

ASHFAQ

[anbu1984]

Check this