topic Re: Set Analysis / Expressions in QlikView

Set Analysis / Expressions

Wed, 26 Nov 2014 10:34:17 GMT

Dimension limit allows us to show First n values. Is it possible to show some values between n and m indices? I have attached a sample here. I would like to skip displaying the values for first 2 and last 2 years. Just show the values corresponding to the years left in between. How can this be achieved by using set analysis in expression.

Re: Set Analysis / Expressions

Wed, 26 Nov 2014 10:41:20 GMT

Hi Nishant,

you can have a start and end year variable which can drive your set analysis yes, see example.

That allows users to drive the range they are after, if you just wanted a hard rule of removing the lowest and greatest two years then hide the variables and code them accordingly.

hope that helps

Joe

Re: Set Analysis / Expressions

rubenmarin — Wed, 26 Nov 2014 10:41:32 GMT

Hi, in expression you can use:

Only({<Year={">=$(=Min({1} Year)+2)<=$(=Max({1} Year)-2)"}>} Employees)

Re: Set Analysis / Expressions

Anonymous — Wed, 26 Nov 2014 10:44:33 GMT

Hi Nishant

Please find the attached file

Regards

Harsha

Re: Set Analysis / Expressions

Gysbert_Wassenaar — Wed, 26 Nov 2014 11:01:30 GMT

Perhaps like this: sum({<Year={'>$(=min({1}Year,2))<$(=max({1}Year,2))'}>}Employees)

Re: Set Analysis / Expressions

Wed, 26 Nov 2014 14:04:22 GMT

Hi Joe

You ignored the condition that was already there on that expression. I would need that condition as well. Can you suggest a way out?

Re: Set Analysis / Expressions

Wed, 26 Nov 2014 14:21:02 GMT

The conditional you set was a calculation condition i.e should the expression show or not.

You can just enable that again if it's required, as all I have adjusted is the expression itself to be relative to the min/max year variables