Set Analysis

[alis2063]

i have 10 years data in QVD & we are just want to get 2013 year data in table only

so i have  written below set analysis but it is getting 10 years data,

=SUM({$<Year= {2013}>}  GrossAmount)

is there any issues in set analysis

[Anil_Babu_Samineni]

Set analysis looks ok to me. May be check field Name like Year ???

[alis2063]

‌I have ccalculated the year from date as year(date) .i guess it is treated as string or some other data type.

Ok

[effinty2112]

Hi Ali,

Do a quick check of your data with a straight table of dimension Year and expression Sum(GrossAmount).

good luck

Andrew

[sunny_talwar]

You did Year(Date) in the script to create a year field? Can you share a sample or images to show how date and year looks like?

[sasiparupudi1]

If year is a dimension created in the script,your set analysis should filter data correctly.Else,

May be try

SUM({$<Date= {'>=''2013-01-01''<=''2013-12-31'''}>}  GrossAmount)

Assuming that your Date field value in the odbc format

Hth

Sasi

[Anil_Babu_Samineni]

Year(date) is not the string it consider as Number only. Can you show the Year field in list box as image. Check how the number are (i mean right side / left side)