topic Re: Help in QlikView

Help

panipat1990 — Fri, 23 Oct 2015 11:24:59 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........Show Only In Straight Table............ Please Help Me....

Feb2015

2000

3000

4000

5000

7000

8000

21200

Mar2015

5000

3000

12000

14000

17000

76000

Apr2015

200

1200

1340

1500

1234

May2015

5000

6700

7600

8700

Jun2015

5600

4500

8700

Jul2015

12345

5678

Aug2015

123456

Re: Help

srchilukoori — Fri, 23 Oct 2015 18:26:29 GMT

Hi,

Please post sample data so an appropriate transformation can be built.

Thanks.

Re: Help

Fri, 23 Oct 2015 19:51:12 GMT

Hi Gourav,

There are a few ways to handle this..

1. Create set analysis expressions for each required column:

a. First Column = sum({<Month = {'Feb2015'}>}Sales)

b. Second Column = sum({<Month = {'Mar2015'}>}Projected Sales)

2. Create a single dynamic expression:

a. Sum({<Month={"=sum(Sales)>0"}>}Sales) + sum({<Month={"=sum(Sales)=0"}>}Projected Sales)

- This will give you sum of sales for months where sales exist and projected for when there are no sales.

Re: Help

MarcoWedel — Fri, 23 Oct 2015 21:40:49 GMT

Hello Panipat1990,

please don't post the same question multiple times and continue this topic in your original thread Logic‌

where petter-s‌proposes a really nice solution to you. He surely deserves an answer for that.

So do all the other community members who spent their time working on Re: Logic to your questions.

hope this helps

regards

Marco