Logic

[panipat1990]

Hi Team,

          I Have a Requirement..I am new in qlikview..please Help Me....My Requirement Is ......I am sitting in Feb 2015..and i want to see Feb 2015's Actual Data And Mar,Apr,May,Jun,Jul,Aug,Sep,Oct's    Projected data...... This Pink Value Show Actual Data...And Other Show Projected Data(ForeCasting Data).............Please Help Me........

Header 1	Feb2015	Mar2015	Apr2015	May2015	Jun2015	Jul2015	Aug2015	Sep2015
Feb2015	2000	3000	4000	5000	7000	8000	21200	22000
Mar2015		5000	3000	12000	14000	17000	76000	9876
Apr2015			200	1200	1340	1500	1234	1112
May2015				5000	6700	7600	8700	9000
Jun2015					5600	4500	8700	9876
Jul2015						12345	5678	9876
Aug2015							123456	09876
Sep2015								19087

[jsingh71]

Share sample data then it will be easy to give the solution.

[#3]

Please Share some sample data and information about the Forecasting like how will you get the numbers .

[petter]

One way of getting the layout you show is to use a Pivot Table and make use of an if to select the expression to use based on whether you need to show Actual or Projected values. The diagonal that is your Actual values can be determined in a Pivot by checking whether ColumnNo() = RowNo() (both special functions in an expression):

[panipat1990]

Actual Data
50000
60000
70000
80000
90000
100000
10000
20000
30000
400000
600000
50000
120000
43400
98000
340000
67000
65000
90078

Projected Data
100000
200000
300000
400000
500000
600000
700000
800000
900000
100000
1100000
1200000
1300000
1400000
1500000
1600000
1700000
1800000
1900000
2000000

[MarcoWedel]

Hi,

did you have time to review and close some of your 20 threads?

Panipat1990

thanks

regards

Marco

[panipat1990]

Hello Marco,

Yes, i have reviewed and closed my 20 threads.

Thanks

Gourav

[MarcoWedel]

Hello Gourav,

I cannot find a single of your threads closed:

You can close threads by selecting a correct answer.

hope this helps

regards

Marco

[panipat1990]

Hi Sir,

      This Is Pivot Table......But I Want to  Show Only In Straight Table.....Please Help Me...Only In Straight Table....

Header 1	Feb2015	Mar2015	Apr2015	May2015	Jun2015	Jul2015	Aug2015	Sep2015
Feb2015	2000	3000	4000	5000	7000	8000	21200	22000
Mar2015		5000	3000	12000	14000	17000	76000	9876
Apr2015			200	1200	1340	1500	1234	1112
May2015				5000	6700	7600	8700	9000
Jun2015					5600	4500	8700	9876
Jul2015						12345	5678	9876
Aug2015							123456	09876
Sep2015								19087

[MarcoWedel]

Hi,

is this what you are looking for?

hope this helps

regards

Marco