year limit in set analysis

[#1]

hi all,

I have data from the month of 2000 to 2011 but i want to show it in charts only from 2010 to 2011 (in set analysis).

any idea please

regards

[#2]

Hello Usha,

may be the anwser is too easy, but what about this:

sum( {<Year={'2010', '2011'}>} Value)

I didn't check the syntax, but I hope it helps anyway.

Regards, Roland

[#3]

May be I do not quite understand your requirement, but could a simple year statement in the set analysis solve your problem:

e.g. sum( {<Year = {">= '2010'"}>} Measure )

[hkg_qlik]

Hi Usha,

Please find the attached demo .qvw file solution.

Note: syntax used:

sum( {<Year={'2010', '2011'}>} Sales)

Regards,

H