Range in TableBox

[#1]

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)

20

15

25

150

so on...

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

Thnks

[#2]

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;

[#3]

Use this code at back end.

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

[#4]

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

[#5]

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

[#6]

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

[#7]

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

[#8]

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

[#9]

HI ,

Please find the attached application.

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

If any problem you are most welcome 🙂

[#10]

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.