Announcements
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Get All Data Between 2 Calculated Values

Hi Qlik Masters,

Greetings.

I have a calculated Fact table like so :

ProductNameYTDValue

Product1

1000
Product22000
Product33000
Product44000
Product55000
Product66000
Product77000
Product88000
Product99000
Product1010000

**Note: YTDValue is derived from an expression which I stored into a variable. I named it vYTDValue.

I have a slider that lets users to choose in range between 0-100(in Percent), and store that value to a variable--say "vRangeInput".

My objective is to produce a straight table with a list of data within a range +/- vRangeInput multiplied with YTDValue from selected ProductName.

For Example:

If the user chose Product6 in the list box (which has YTDValue = 6000 ) and in the slider the user chose 20%, then it should show all of ProductName that has YTDValue between 6000*80% = 4800 AND 6000*120% = 7200.

80% comes from 100%-20%, and 120% comes from 100%+20%.

The result should be something like this:

ProductNameYTDValue
Product55000
Product66000
Product77000

The table above shows all ProductName that has YTDValue between 4800 and 7200.

How can I achieve this in Qlikview? It seems a bit tricky.

Feel free to ask me if I didn't explain the problem clearly. And thank you in advance.

1 Solution

Accepted Solutions
MVP
5 Replies
MVP

Would you be able to share a sample where you have set up the slider and list box?

Anonymous
Not applicable
Author

Hi Sunny T,

Yes sure you can see the sample qvw in my original post. I had to edit my post because I forgot to attach the sample file.

MVP

This?

Anonymous
Not applicable
Author

Hi Sunny,

Yes exactly right.

That's what I've been struggling with.

Thank you very much for your help.