topic Re: Logic in QlikView

Logic

panipat1990 — Mon, 19 Oct 2015 11:25:04 GMT

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

Re: Logic

jsingh71 — Mon, 19 Oct 2015 12:01:02 GMT

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

Re: Logic

Mon, 19 Oct 2015 13:11:07 GMT

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

Re: Logic

petter — Mon, 19 Oct 2015 13:23:41 GMT

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):

Re: Logic

panipat1990 — Tue, 20 Oct 2015 05:31:52 GMT

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

Re: Logic

MarcoWedel — Tue, 20 Oct 2015 20:53:48 GMT

Hi,

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

Panipat1990

thanks

regards

Marco

Re: Logic

panipat1990 — Thu, 22 Oct 2015 11:19:02 GMT

Hello Marco,

Yes, i have reviewed and closed my 20 threads.

Thanks

Gourav

Re: Logic

MarcoWedel — Thu, 22 Oct 2015 20:56:44 GMT

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

Re: Logic

panipat1990 — Mon, 26 Oct 2015 06:29:11 GMT

Hi Sir,

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

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

Re: Logic

MarcoWedel — Tue, 27 Oct 2015 00:06:21 GMT

Hi,

is this what you are looking for?

hope this helps

regards

Marco

Re: Logic

panipat1990 — Tue, 27 Oct 2015 08:37:55 GMT

Hi Sir,

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

Re: Logic

MarcoWedel — Tue, 27 Oct 2015 20:17:05 GMT

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

Re: Logic

panipat1990 — Wed, 28 Oct 2015 10:17:24 GMT

Hi Sir,

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

Logic

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

Re: Logic

MarcoWedel — Thu, 29 Oct 2015 00:02:22 GMT

Hi,

maybe like this?

hope this helps

regards

Marco

Re: Logic

panipat1990 — Sat, 20 Feb 2016 19:26:15 GMT

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