topic Re: tricky question? in QlikView

tricky question?

Anonymous — Wed, 15 Oct 2014 12:48:54 GMT

Hi ,

i have data for jan 2013 sales is 100 and dec 2013 sales is 1200 , remining feb,mar,....oct,nov i dont have

but my req is

i want see the data for

jan is 100

feb is 100

mar is 200(jan+feb)

apr is 400(jan +feb+mar)

like this i want till dec(jan+....+dec) .

i have to do this in script level only not in chart level using accumulation.

how ?

Re: tricky question?

MK_QSL — Wed, 15 Oct 2014 12:50:48 GMT

Use RangeSum, Above Functions in script...

Re: tricky question?

Anonymous — Wed, 15 Oct 2014 12:54:12 GMT

can u give me a expression

Re: tricky question?

Wed, 15 Oct 2014 12:54:45 GMT

Hi,

Can you plz provide the code

Re: tricky question?

MK_QSL — Wed, 15 Oct 2014 13:03:01 GMT

Sales:

Load

Date#(Month,'MMM') as Month,

Sales Inline

[

Month, Sales

Jan, 100

Feb, 200

Mar, 300

Apr, 400

May, 500

Jun, 600

Jul, 700

Aug, 800

Sep, 900

Oct, 1000

Nov, 1100

Dec, 1200

];

Final:

Load

Month,

Sales,

RangeSum(Peek('TotalSales'),Sales) as TotalSales

Resident Sales

Order By Month;

DROP Table Sales;

Re: tricky question?

Wed, 15 Oct 2014 13:08:04 GMT

Hi Manish,

but here we have Jan and Dec in Month field,we dont have Feb to Nov values in Month field.

Re: tricky question?

Wed, 15 Oct 2014 13:10:53 GMT

Hi,

Sales:

Load

Date#(Month,'MMM') as Month,

Sales Inline

[

Month, Sales

Jan, 100

Dec, 1200

];

Sales1:

Load

Date#(Month,'MMM') as Month,

Sales Inline

[

Month, Sales

Feb, 0

Mar,0

Apr, 0

May,0

Jun, 0

Jul, 0

Aug, 0

Sep, 0

Oct, 0

Nov, 0

];

Final:

Load

Month,

Sales,

RangeSum(Peek('TotalSales'),Sales) as TotalSales

Resident Sales

Order By Month;

Re: tricky question?

MK_QSL — Wed, 15 Oct 2014 13:12:21 GMT

Cant get you... can you please be more specific, with example?

Re: tricky question?

Wed, 15 Oct 2014 13:15:47 GMT

Actually here we have Like this

Tab:

Month Sales

Jan 100

Dec 1200

But here the requirement is we have data like this

Tab:

Month, Sales

Jan, 100

Feb, 200

Mar, 300

Apr, 400

May, 500

Jun, 600

Jul, 700

Aug, 800

Sep, 900

Oct, 1000

Nov, 1100

Dec, 1200

So here I added the Feb to Nov values using inline table with all sales value is 0.

is there any another way to achieve it?

Re: tricky question?

Anonymous — Wed, 15 Oct 2014 13:16:27 GMT

month filed is having only jan and dec sales .

no feb,mar...nov

here we have to create inline to get names of feb ,mar,....nov and we need to do the accumlation as above i said

Re: tricky question?

MK_QSL — Wed, 15 Oct 2014 13:24:14 GMT

Sales:

Load

Date#(Month,'MMM') as Month,

Sales

Inline

[

Month, Sales

Jan, 100

Feb, 200

Dec, 300

];

Join

Load

Date#(Month,'MMM') as Month

Inline

[

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];

Final:

Load

Month,

Sales,

RangeSum(Peek('TotalSales'),Sales) as TotalSales

Resident Sales

Order By Month;

DROP Table Sales;