how to Finding range values in qlikview

[#1]

Hi All,

Regards,

Sai Madhu

[Anonymous]

Hi Sai,

You can do this by adding two input text fields and associate them to a variable

and then use a set analysis to display the total of sales according to the range selected:

=sum({<[Range-1] = {'=$(vMinVal)'},[Range-2] = {'=$(vMaxVal)'} >}sales)

I just have one question, do you need to consider any value in Range-1 and Range-2 inside the interval defined?

Regards,

-Karla

[rahulhv1]

It  is very simple. you need to use qlikview function intervalmatch.

[#4]

Hi karla,

can you Please create one sample QVD file using this data

[Anonymous]

Hi Sai,

Please refer to the attached file with the example provided above.

Regards,

- Karla

[#6]

how to created text fields    

[#7]

can you please Send me the QVD File

[Anonymous]

To create the input boxes, go to Layout --> New Sheet object --> Input box

Regards,

[Anonymous]

I have not used a QVD, instead I used a load inline of the information that you provided in the excel file.

Regards,