Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3823.Book.xlsx:550:0]
Hi all,
I would like to show the scatter chart with parameters sum(profit) and sum(income) with company as dimension
also i want to use the slider to flter the chart ranges....
i want to use two sliders....
one is for sum(profit) and another one is for sum(income.).......
if i select the profit range b/w 5000 to 10000,the chart should show the sum(profit) values b/w 5000 to 10000
also if i select the income range b/w 25000 to 30000,the chart should show the value b/w that value only..
I attached one sample excel file...
could you pls anyone help me.....
thanks in advance
Well, the simple approach is to just highlight the profit and income range of interest in the chart itself.
But you could make variables for MinProfit, MaxProfit, MinIncome and MaxIncome. Set up two multi-value sliders using these variables. Set a static min and max for each dimension in your chart equal to these variables. See attached.
Probably other approaches as well.