topic Range in TableBox in QlikView

Range in TableBox

Tue, 15 Feb 2011 13:12:40 GMT

I am attaching an image of my requirement in QV 10.

Can anyone else look it and tell me how can i work it .

EdgeChipLength is a created field for my table. In this i am having nearly 1700 values. My Requirement is if i given a range condition then it should display its count between the range.

Ex: EdgeChipLength(field)

15(values)

150

so on...

Once check the attachement you will get clear Idea. Please reply as soon as possible.

Thnks

Range in TableBox

Tue, 15 Feb 2011 13:26:32 GMT

HI,

use Interval Match for creatring this slabs .....

Code :

Interval_match:

LOAD * INLINE [

Start, End, EdgeChipLength_Slab

, 0, '0'

1, 10, '1-10'

11, 20, '11-20'

21, 30, '21-30'

;

intervalmatch(EdgeChipLength)

load

Start, End

resident Interval_match;

Range in TableBox

Tue, 15 Feb 2011 13:29:01 GMT

Use this code at back end.

And use this filed "EdgeChipLength_Slab " at your chart as dimension where you need slabs.

Range in TableBox

Tue, 15 Feb 2011 13:34:19 GMT

I would also suggest you to use , Straight table /Pivot for it

Range in TableBox

Tue, 15 Feb 2011 14:20:48 GMT

Hi can you explain little bit clearly of the process. I am new to QV. So please tell me step by step process for how to work which you sended.

Thnks

Range in TableBox

Tue, 15 Feb 2011 14:25:04 GMT

please share you apllication with the data you are using . I will be making it for you.

Range in TableBox

Tue, 15 Feb 2011 14:37:49 GMT

How can i attach Qlikview file in this post. I don't know how to send it. Can you tell how can i attach to it.

thnks

Range in TableBox

Tue, 15 Feb 2011 14:56:34 GMT

Hi i sending you my working report attachement . And finally it should look like this. Please help me to complete this.

In this image it should count how many values present in b/w the range i.e; >=15 and <20 its having count 8. Same process to all.

Thnks

Range in TableBox

Wed, 16 Feb 2011 07:14:53 GMT

HI ,

Please find the attached application.

Save and reload it. Data will come according to your slab.

If any problem you are most welcome 🙂

Range in TableBox

Wed, 16 Feb 2011 08:42:41 GMT

Hey Ashwin my QV 10 in not a Full Licensed Version, so i am unable to open the which you sended attachement QV file.

Please if you don't mind can you send me the ScreenShots which you make modified in the QV file.

Thnks for your all replies and spending your valuable time with me.