Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead 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.


--Adam Ginza--

Message was edited by: Adam Ginza Added Attachment

1 Solution

Accepted Solutions
sunny_talwar

5 Replies
sunny_talwar

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,

Thanks for replying.

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.

--Adam Ginza--

sunny_talwar

This?

Capture.PNG

Anonymous
Not applicable
Author

Hi Sunny,

Yes exactly right.

That's what I've been struggling with.

Thank you very much for your help.

--Adam Ginza--

rendiyan
Partner - Creator
Partner - Creator

same case, this is exactly what i need too.

thx