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

[panipat1990]

Hi Sir,

        Tell Me Logic Behind it For Making Straight Table......Please Help Me....

[MarcoWedel]

Hi,

I'm currently busy but can prepare some screen shots later.

Maybe you can mark appropriate answers correct in your open threads in the meantime:

thanks

regards

Marco

[panipat1990]

Hi Sir,

•         Tell Me Logic Behind it For Making Only Straight Table......Please Help Me....

Logic

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 · Accepted solution]

Hi,

maybe like this?

hope this helps

regards

Marco

[panipat1990]

Dear Marco,

I have closed all threads which were opened earlier.

Actually, i was unaware for closing the same.

Thanks for guiding me by sharing this above snapshot.

Regards

Gourav