topic Re: year limit in set analysis in QlikView

year limit in set analysis

Tue, 16 Aug 2011 15:25:10 GMT

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

year limit in set analysis

swuehl — Tue, 16 Aug 2011 15:30:01 GMT

Use a set expression like

{<Year={2010,2011} >}

e.g. in sum({<Year={2010,2011}>} Sales) as expression, Year and Month as dimension

Is that what you need?

Re: year limit in set analysis

its_anandrjs — Tue, 16 Aug 2011 15:40:38 GMT

Hi Usha,

See the sample file on that in chart calculation i use the condition for Month and Year only for March and Year for 2010 and 2011. Use the sample for your applications and condition. I use for Month as well as Year for in a Set Analysis code =Sum({<Year = {2010,2011}, Month = {'Mar'} >} value)

Hope this helps you.

Regards,

Anand

Re: year limit in set analysis

thanomjit — Wed, 17 Aug 2011 06:49:06 GMT

Please try

ILYear=2011

ILMonth=03

Expression :

Sum( {< Period = {">=$(=Date(AddMonths(Date#(ILYear&ILMonth&'01','YYYYMMDD') , -11 ),'YYYYMM') & '') <= $(=Date(AddMonths(Date#(ILYear&ILMonth&'01','YYYYMMDD') , 0 ),'YYYYMM') & '')"} >} Amount)

Result :

Sum Amount from 201103 to 201004