topic Re: Get All Data Between 2 Calculated Values in QlikView

Get All Data Between 2 Calculated Values

Anonymous — Tue, 31 Jan 2017 12:04:20 GMT

Hi Qlik Masters,

Greetings.

I have a calculated Fact table like so :

ProductName	YTDValue
Product1	1000
Product2	2000
Product3	3000
Product4	4000
Product5	5000
Product6	6000
Product7	7000
Product8	8000
Product9	9000
Product10	10000

**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:

ProductName	YTDValue
Product5	5000
Product6	6000
Product7	7000

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

Re: Get All Data Between 2 Calculated Values

sunny_talwar — Tue, 31 Jan 2017 13:38:47 GMT

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

Re: Get All Data Between 2 Calculated Values

Anonymous — Tue, 31 Jan 2017 14:41:31 GMT

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--

Re: Get All Data Between 2 Calculated Values

sunny_talwar — Tue, 31 Jan 2017 14:47:28 GMT

This?

Re: Get All Data Between 2 Calculated Values

Anonymous — Tue, 31 Jan 2017 15:09:41 GMT

Hi Sunny,

Yes exactly right.

That's what I've been struggling with.

Thank you very much for your help.

--Adam Ginza--

Re: Get All Data Between 2 Calculated Values

rendiyan — Tue, 31 Jan 2017 15:14:53 GMT

same case, this is exactly what i need too.

thx