topic Re: General Expression in QlikView

General Expression

Wed, 04 Feb 2015 12:22:55 GMT

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

Re: General Expression

Wed, 04 Feb 2015 12:23:35 GMT

what does $ and <> means

Re: General Expression

avinashelite — Wed, 04 Feb 2015 12:25:18 GMT

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

Re: General Expression

avinashelite — Wed, 04 Feb 2015 12:26:03 GMT

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

Re: General Expression

Wed, 04 Feb 2015 12:32:14 GMT

Hi,

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

Manuel Coterillo.

Re: General Expression

Wed, 04 Feb 2015 12:34:12 GMT

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