Help

[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........Show Only In Straight Table............ Please Help Me....

Header 1	Feb2015	Mar2015	Apr2015	May2015	Jun2015	Jul2015	Aug2015
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

[srchilukoori]

Hi,

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

Thanks.

[#3]

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.

[MarcoWedel]

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