topic What if analysis for Non Available data in QlikView

What if analysis for Non Available data

Fri, 28 Sep 2012 11:58:28 GMT

Hi Friends

I have a chart which shows current year month wise sales. Months are from January 2012 to Jun 2012.

I want to implement the WHAT IF capablity. on the months which are yet to come .

When user selects some value such as 15 % then the chart should populate data for the non existing data months :;

For eg :

If Last month is Jun 2012 and its value is

buzzy996 — Fri, 28 Sep 2012 12:28:31 GMT

pfa,

steps:

1.first create bar chat along with ur values.

2.create slider object

3.create one variable(here Variable1),set values for slider accordingly what ever u want (here -30 to 30)

4 and use that variable in ur expression.

hope it helps.

Mon, 15 Oct 2012 11:21:27 GMT

Hi,

For Example:

Let us take Amt field is there in your dimension,

For forecasting for future month you need to create Variable (Ctrl+Alt+V).

Name the variable as Var1 and value for the same

In that variable you mentioned your % or any value. In Slider you define it form (-15 to 15).

In Bar chart or any object. Mentioned the Expression as Amt*Var1.