Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share a sample where you have set up the slider and list box?
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--
This?
Hi Sunny,
Yes exactly right.
That's what I've been struggling with.
Thank you very much for your help.
--Adam Ginza--
same case, this is exactly what i need too.
thx