topic set analysis in Qlik Learning Discussions

set analysis

Tue, 13 Jan 2015 10:50:08 GMT

Hi team

I have one scenario,please help me to solve

I have data from 2003 to 2015

if i click 2003 i did not get the sales of 2003, from 2004,sales will be displyed on the chart

same way click on 2004. from 2005 sales will be displayed

MK_QSL — Tue, 13 Jan 2015 10:56:07 GMT

may be you have given criteria < and >....

USE <= AND >= in your set analysis

nikhilgarg — Tue, 13 Jan 2015 11:01:09 GMT

HEy,

Can you share the script you have written for this ??

Gysbert_Wassenaar — Tue, 13 Jan 2015 11:02:42 GMT

sum({<MyYearField={'$(=only(MyYearField)+1)'}>} sales )

nikhilgarg — Tue, 13 Jan 2015 11:18:05 GMT

Hey,

But Only() will be used in case if it has only 1 value.

Isn't it ??

Thanks

Agis-Kalogiannis — Fri, 16 Jan 2015 13:16:13 GMT

The way Vijaya describes the problem though implies only one selection so Gysbert's solution will work.

Unless he can become more specific.

Sat, 17 Jan 2015 08:31:15 GMT

thank you all

Agis-Kalogiannis — Mon, 19 Jan 2015 17:51:18 GMT

Hi Vijaya

Could you please mark one of the answers as Helpful or Correct so as to close the discussion?

Thanks

Agis