topic Re: set analysis in QlikView

set analysis

satishqlik — Sat, 02 May 2015 06:33:22 GMT

Hello experts,

How to get next 5 years data, If I select 2010 in the year field

exp:Sum({<year={">2010<=2015"}>}sales)

By using set analysis how can we approach dynamically.?

I tried below exp like

Sum({<year={>$(=only(year))<=$(only(year)+5)}>}sales)

But it hasn't worked.

I would appreciate if anyone can help me out in this.

Thanks in adv!!

Anonymous — Mon, 04 May 2015 06:49:44 GMT

Hi,

Try like this

sum({<year = {'>=$(=GetFieldSelections(year))<=$(=GetFieldSelections(year)+5)'} >}sales)

Regards,

Greeshma

satishqlik — Tue, 05 May 2015 03:08:32 GMT

Thanks for answering I'll try and get back to you!

Agis-Kalogiannis — Tue, 05 May 2015 08:38:37 GMT

Hi Satish

the reason why your expression does not work is because of some missing quotes.

Try the following:

Sum({<year={'>$(=only(year))<=$(only(year)+5)'}>}sales)

Also please note that year and sales are case sensitive.

Thanks

Agis

Anonymous — Thu, 09 Jul 2015 18:04:54 GMT

hi Satish, if your query is solved please close the thread by tagging it as correct answer. So that way someone can either learn from your question.

prabhas277 — Thu, 09 Jul 2015 18:37:06 GMT

Hi satish,

please try this then it will come..

=sum({<year={">=$(=Min(year))<=$(=Min(year)+4)"}>}popu)

all fields are case sensitive check it properly

if it will helpful then give the correct answer

Regards,