topic Re: Range on each rows. in QlikView

Range on each rows.

suzel404 — Thu, 29 May 2014 06:14:45 GMT

Hi all,

I have range. When I select Range I can get the previousRange et ForwardRange.

Example : I select 1500 - 200 range I can see in straight table :

1250 - 1500

1500 - 2000

2000 - 2500

Is there a way to get this directly in dimension without using the Set Analysis in expression ?

Thank you for your help.

Thu, 29 May 2014 06:43:22 GMT

Hi,

Since you have written "Range=" in your st. table expression, the table does not get affected for Range selections.

Change your exp to '=Only({<Id={$(=Id-1), $(=Id), $(=Id+1)}>}Range)' and check, you will get one row.

Regards,

Prabhu

suzel404 — Thu, 29 May 2014 11:03:40 GMT

Hi Prabhu,

If I use " Only({<Id={$(=Id-1), $(=Id), $(=Id+1)}>}Range)'" I get one row. I don't want one row but 3 rows.

I select range 1500 - 2000 the corresponding Id is 811. So I would like to get :

1250 - 1500 (corresponding Id = 810, previous range)

1500 - 2000 (corresponding Id =811, my current selection)

2000 - 2500 (corresponding Id =812, forward range)

I would like this result calculated in Dimension tab and not in expression Tab, if it is possible.

tresB — Thu, 29 May 2014 11:43:52 GMT

You can, but that would make things more complex. Calculated dimension:

=ValueList( $(=chr(39)&Concat({<Range=>}Aggr(Only({<Id={$(=Id-1), $(=Id), $(=Id+1)}, Range=>}Range),Range),chr(39)&','&chr(39))&chr(39)))

PFA

suzel404 — Thu, 29 May 2014 11:54:53 GMT

Hi Tresesco,

Thank you. Expression is more complex but very interesting. One last thing, how can I add value in expression:

if range = 1500 - 2000, 10

if range = 1250 - 1500, 7

if range = 1500 - 2000, 2

tresB — Thu, 29 May 2014 12:00:11 GMT

The complexity deepens from here. . You have to write expression like:

=If( Valuelis(....)='This', 'ThenThis', If(....))

The same can be cleverly written using Pick(Match(....)).

But I guess you should rethink if this is really needed or you have alternate option.

suzel404 — Thu, 29 May 2014 12:05:57 GMT

Many Thank !!