topic Re: Rename name in Dimension in QlikView

Rename name in Dimension

Anonymous — Thu, 18 Dec 2014 20:25:07 GMT

Hi guys,

I'd like to dynamically rename of tags in a dimension.

When I click on any ID from list box ID, in the chart "Output" selected ID should called "0", previous 2 ID - "-1", "-2" and next 2 ID "+1","+2"

Please find attached file.

Thanks,

Re: Rename name in Dimension

julian_rodriguez — Thu, 18 Dec 2014 20:36:20 GMT

Hello Vladimir

May be this calculated dimension works for you:

=Aggr(Rank(only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}Text)), ID)-3

Regards!

Re: Rename name in Dimension

Anonymous — Thu, 18 Dec 2014 20:49:57 GMT

Thanks for helping.

Order should be appositive.

Actually I need to add wording like step-1, step-2 and so on.

If it's not doable, I can use only numbers

Re: Rename name in Dimension

Anonymous — Fri, 19 Dec 2014 17:03:03 GMT

I fixed the appositive order

=Aggr(Rank(-only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}ID)), ID)-3

but I have problem when I select the first number, it should be RANK -1

=Aggr(Rank(only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}Text)), ID)-1

if I select the second number, it should be RANK -2

=Aggr(Rank(only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}Text)), ID)-2

How to easy combine 3 conditions?

Please attached my file.

Re: Rename name in Dimension

Anonymous — Fri, 19 Dec 2014 18:46:38 GMT

I found out how to do with condition

IF(COUNT(TOTAL({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}ID)=1,

Aggr(Rank(only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}Text)), ID)-1,

IF(COUNT(TOTAL({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}ID)=2,

Aggr(Rank(only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}Text)), ID)-2,

IF(COUNT(TOTAL({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}ID)>=3,

Aggr(Rank(only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}Text)), ID)-3)))

It works.

But it doesn't work in some my cases.

Because key ID sometimes doesn't match with position

Maybe something like this

only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}

IF(ID=ID,'Step',

IF(ID-1=ID-1,'Step-1',

IF(ID+1=ID+1,'Step+1')))

)

Re: Rename name in Dimension

Anonymous — Fri, 19 Dec 2014 20:57:04 GMT

Is it possible to add a condition like if ID take place number 1 in the rank position, do this???

Re: Rename name in Dimension

Anonymous — Fri, 19 Dec 2014 21:08:18 GMT

What condition possible to add to get it?

Re: Rename name in Dimension

Anonymous — Fri, 19 Dec 2014 21:40:07 GMT

maybe firstvalue() or firstindex() or firstsortedvalue()

????????????????????????????????

Re: Rename name in Dimension

Anonymous — Mon, 22 Dec 2014 17:02:23 GMT

Any ideas, guys?

Maybe use pick() , when ID takes 1 or 2 places, use the same rank expression just -1 or -2.

Re: Rename name in Dimension

Anonymous — Mon, 22 Dec 2014 20:06:28 GMT

I resolved the issue.

I created a varaible vDRank=Aggr(Rank(-only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}ID)), ID)

In dimension:

Aggr(Rank(-only({<ID=,FI_ID={">=$(=max(FI_ID)-2)<=$(=max(FI_ID)+2)"}>}ID)), ID)-vDRank