Scatter chart using slider

Mon, 04 Oct 2010 12:20:27 GMT

[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

Scatter chart using slider

johnw — Mon, 04 Oct 2010 23:40:59 GMT

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.

topic Scatter chart using slider in QlikView

Scatter chart using slider

Scatter chart using slider