topic Re: Set Analysis in QlikView

Set Analysis

alis2063 — Sun, 06 Aug 2017 17:41:43 GMT

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

Re: Set Analysis

Anil_Babu_Samineni — Sun, 06 Aug 2017 17:43:44 GMT

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

Re: Set Analysis

alis2063 — Sun, 06 Aug 2017 18:08:25 GMT

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

Re: Set Analysis

effinty2112 — Sun, 06 Aug 2017 20:55:10 GMT

Hi Ali,

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

good luck

Andrew

Re: Set Analysis

sunny_talwar — Mon, 07 Aug 2017 00:42:03 GMT

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?

Re: Set Analysis

sasiparupudi1 — Mon, 07 Aug 2017 01:31:08 GMT

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

Re: Set Analysis

Anil_Babu_Samineni — Mon, 07 Aug 2017 03:22:40 GMT

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)