General Expression

[#1]

hi

I have an expression which i am not able to understand

please help.

The expression is mentioned below:

=sum({$<[Fiscal Quarter Name]>} [Visit Count])

Fiscal Quarter Name Contains:                                        Visit Count Contains:

Q1FY2013                                                                                     1

Q2FY2013                                                                                     2

Q3FY2013                                                                                     3

Q4FY2013                                                                                     4

[#2]

what does $ and <> means

[avinashelite]

they are counting the sum of visit count based on the current selection of Fiscal Quarter Name.

$ is to refer the current selection and Fiscal Quarter Name is the filed

[avinashelite]

<> is the start of set analysis that to choose a value from the particular set

[#5]

Hi,

I think the attached document will help you to understand how works Set Analysis.

Manuel Coterillo.

[#6]

Hi Deepak,

your expression is summing the field [Visit Count].

The expression is being further adjusted by set analysis.

{$<[Fiscal Quarter Name]>}

The $ element tells the sum to respect current selections. Between the <> is any modifier beyond this that should be adhered to. In this case any selection in [Fiscal Quarter Name] is being disregarded.

So in basic terms, you are telling QV to sum [Visit Count], using the current selection but ignore any selection made in [Fiscal Quarter Name].

Have a look here maybe for more info on set analysis

http://community.qlik.com/docs/DOC-4951

Hope that helps

Joe