topic Re: how to Finding range values in qlikview in QlikView

how to Finding range values in qlikview

Sat, 09 Apr 2016 03:19:14 GMT

Hi All,

Regards,

Sai Madhu

Anonymous — Sat, 09 Apr 2016 03:41:04 GMT

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 — Sat, 09 Apr 2016 04:09:11 GMT

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

Sat, 09 Apr 2016 05:36:15 GMT

Hi karla,

can you Please create one sample QVD file using this data

Anonymous — Sat, 09 Apr 2016 05:41:45 GMT

Hi Sai,

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

Regards,

- Karla

Sat, 09 Apr 2016 05:44:02 GMT

how to created text fields

Sat, 09 Apr 2016 05:46:46 GMT

can you please Send me the QVD File

Anonymous — Sat, 09 Apr 2016 05:48:46 GMT

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

Regards,

Anonymous — Sat, 09 Apr 2016 05:50:06 GMT

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

Regards,