topic Re: Restricting a Dim Year value to max 2 values in QlikView

Restricting a Dim Year value to max 2 values

Anonymous — Thu, 10 Sep 2015 05:46:01 GMT

Hello,

I am having year as Dimension and want to restrict it upto max two values....

Example: say, I am having 2013,2014,2015,2016....

on the base of selection of master calender it shud give me max two value, in common words like CY vs PY.

How I can do it at dimension level??

Regards,

Balraj Ahlawat

Re: Restricting a Dim Year value to max 2 values

gautik92 — Thu, 10 Sep 2015 05:57:06 GMT

you want to create a variable for previous year and in chart you have to use that variable in expression

then create a input box and call that variable in the inbut box

Re: Restricting a Dim Year value to max 2 values

Anonymous — Thu, 10 Sep 2015 06:05:40 GMT

I have defined a variable into Variable overview named VPY

now at dimension level I am using

If(year>=VPY, year)..

But its not working

Re: Restricting a Dim Year value to max 2 values

jonathandienst — Thu, 10 Sep 2015 06:16:34 GMT

If you define the variable like this:

=(Max(year) - 1)

(where the = sign is part of the variable defintion),

Then you can use it in the way you tried. If the defintion does not include the = sign, then you would need:

If(year >= $(VPY). ....

Re: Restricting a Dim Year value to max 2 values

Anonymous — Thu, 10 Sep 2015 06:21:09 GMT

Jonathan,

I have already tried this but no success..

PFA..

Re: Restricting a Dim Year value to max 2 values

jagan — Thu, 10 Sep 2015 06:24:36 GMT

Hi,

Try like this

Dim : year

Expression: =sum({<year={'>=$(=Max(year) -1)<=$(=Max(year))'}>}sales)

Regards,

Jagan.

Re: Restricting a Dim Year value to max 2 values

jagan — Thu, 10 Sep 2015 06:25:52 GMT

No dimension:

Expression:

Current Year : Sum({<year={'$(=Max(year) -1)'}sales)

Previous Year : Sum({<year={'$(=Max(year))'}sales)

Hope this helps you.

Regards,

Jagan.

Re: Restricting a Dim Year value to max 2 values

Kushal_Chawda — Thu, 10 Sep 2015 06:25:59 GMT

use calculated dimension as below

=aggr(Only({<year={">=$(=max(year)-1)"}>}year),year)

check suppress when values is NULL

see the attached

Re: Restricting a Dim Year value to max 2 values

tresB — Thu, 10 Sep 2015 06:33:31 GMT

PFA. You nneded a preceding '=' in the variable definition.

Re: Restricting a Dim Year value to max 2 values

Anonymous — Thu, 10 Sep 2015 07:03:47 GMT

Jagan,

At expression level I have tried same and it was working.

But I want to try at Dimension level not expression level.

Re: Restricting a Dim Year value to max 2 values

Anonymous — Thu, 10 Sep 2015 07:08:08 GMT

Kush,

not looking what you suggested.

I want like CY vs PY at dimension level. Look at Jagan's suggest but those are at expression level.

Re: Restricting a Dim Year value to max 2 values

tresB — Thu, 10 Sep 2015 07:08:29 GMT

Check the attachment I have given in below reply.

Re: Restricting a Dim Year value to max 2 values

Anonymous — Thu, 10 Sep 2015 07:11:01 GMT

Tresco,

It is not showing like CY vs PY. For max value of year it is giving but not for rest of year's value.

Pls chk.