Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

set analysis

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

Tags (1)
7 Replies
MVP
MVP

Re: set analysis

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

USE <= AND >= in your set analysis

nikhilgarg
Contributor III

Re: set analysis

HEy,

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

Re: set analysis

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


talk is cheap, supply exceeds demand
nikhilgarg
Contributor III

Re: set analysis

Hey,

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

Isn't it ??

Thanks

Employee
Employee

Re: set analysis

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

Unless he can become more specific.

Not applicable

Re: set analysis

thank you all

Employee
Employee

Re: set analysis

Hi Vijaya

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

Thanks

Agis

Community Browser