Dynamic Graphs as per user input

Thu, 03 Jul 2014 07:13:46 GMT

Folks,

Having some query, hope I get some help from here.

Let's say I am having one excel with below kind of data:

CustomerName	Month	SalesData
A1	Jan	150
A2	Jan	200
A1	Feb	250
A2	Feb	250

I will displaying above info in bar graph, Customer Sales Data monthly. all good!

Now below is the situation:

I would like to have some input box in my document, where in user will input some numeric value let's say 2: (variable vInput)

In back ground, an equation will get executed, which will fetch Mar month Sales Data and will display in a graph.

Equation will be like

March month CustA = Feb month sales data + (100 * vInput)

March month CustB = Feb month sales data + (110 * vInput)

So upon calculation (Let's say I will also have button) - so once I feed in the input, hit the button graph will display March month record.

Is this possible, and please guide me how to tackle this situation.

Thanks

Arindam

Re: Dynamic Graphs as per user input

Mon, 07 Jul 2014 07:31:52 GMT

Hi Friends,

I am attaching one qvw which I worked to get the query sorted out that I asked in this forum.

Well I got plenty of helpful topics in this forum, and qvw was created by help of QV forum people only. Please check, the input params and below bar chart populated as per input params.

Please let me know your suggestions.

Thanks

Arindam Roy

topic Re: Dynamic Graphs as per user input in QlikView

Dynamic Graphs as per user input

Re: Dynamic Graphs as per user input