Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

alis2063
Contributor II

Set Analysis

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

Tags (1)
6 Replies
Highlighted

Re: Set Analysis

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
alis2063
Contributor II

Re: Set Analysis

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

Ok

Highlighted
effinty2112
Honored Contributor

Re: Set Analysis

Hi Ali,

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

good luck

Andrew

Highlighted

Re: Set Analysis

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?

Highlighted
sasiparupudi1
Honored Contributor III

Re: Set Analysis

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

Highlighted

Re: Set Analysis

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)