topic Re: Months comparison in % as Expression in QlikView

Months comparison in % as Expression

300sss300 — Fri, 20 Nov 2020 18:02:30 GMT

Hi everyone!

I want to show a line chart with % variation for each month and quarter. (Both Quantity and Value)

Script is as below

LOAD Date,

Year (Date) as Year,

Month (Date) as Month,

Day (Date) as Day,

MonthName (Date) as YearMonth,

Org,

Qty,

Value

...............................

Also please find attached the Data file.

Best Regards

sunindia‌yujiyamane

Re: Months comparison in % as Expression

sunny_talwar — Sun, 06 Dec 2015 13:22:09 GMT

So are you looking for 4 lines on a same chart?

Re: Months comparison in % as Expression

effinty2112 — Sun, 06 Dec 2015 13:27:12 GMT

Hi Khyam,

Add a Qtr field to you load script:

Year (Date) & 'Q' & Ceil(Month (Date)/3) as Qtr,

For monthly variance of Qty create a line chart with dimension Month and these two expressions:

sum(Qty)

(sum(Qty)-RangeSum(Above(Qty,1,1)))/RangeSum(Above(Qty,1,1))

Fro the first expression de-select the 'Line' checkbox in the 'Display Options' part of the Expressions tab.

If you want to show the var in Value in the same chart add

sum(Value)

(sum(Value)-RangeSum(Above(Value,1,1)))/RangeSum(Above(Value,1,1))

As before de-select the 'Line' checkbox for the sum(Value) expression.

For the quarterly variance change the dimension to Qtr.

Hope this helps.

Re: Months comparison in % as Expression

300sss300 — Sun, 06 Dec 2015 13:36:24 GMT

No separate for Months and Quarter

but I am concerned mainly with Months Chart should show variation in % from Jan to Dec (11 Data points)

Best Regards,

Re: Months comparison in % as Expression

300sss300 — Sun, 06 Dec 2015 13:47:40 GMT

Hi Andrew,

Thanks for the reply.

Quarter was added successfully as field.

But the other part related to variation is not working.

Best Regards,

Re: Months comparison in % as Expression

effinty2112 — Sun, 06 Dec 2015 13:59:51 GMT

Hi Khyam,

Have a look at this qvw. It gives this chart for month comparison of qty. Nothing for Jan as no previous month data.

Dimension: Month

Expressions: sum(Qty)

(sum(Qty)-RangeSum(Above(Qty,1,1)))/RangeSum(Above(Qty,1,1))

the first expression is not shown by de-selecting the 'Line' display option

Re: Months comparison in % as Expression

sunny_talwar — Sun, 06 Dec 2015 14:16:15 GMT

May be like this:

Expression: =(Sum(Qty)-Above(Sum(Qty)))/Above(Sum(Qty))

Re: Months comparison in % as Expression

300sss300 — Sun, 06 Dec 2015 14:47:49 GMT

I have used this as second expression and unselected line option for Sum(Value) expression.

(sum(Value)-RangeSum(Above(Value,1,1)))/RangeSum(Above(Value,1,1))

its not working

Re: Months comparison in % as Expression

300sss300 — Sun, 06 Dec 2015 15:08:57 GMT

Thanks!

It is working.

But image is like this. what is missing???

Re: Months comparison in % as Expression

sunny_talwar — Sun, 06 Dec 2015 16:15:34 GMT

How you want to see the image as?

Re: Months comparison in % as Expression

300sss300 — Mon, 07 Dec 2015 05:45:13 GMT

Its working

Thanks

Re: Months comparison in % as Expression

300sss300 — Mon, 07 Dec 2015 05:46:11 GMT

Thanks Andrew for your support.

I ll try second part later in new file.

Best Regards!

Re: Months comparison in % as Expression

300sss300 — Tue, 26 Apr 2016 06:14:41 GMT

Now I need 04 lines on the same chart...

Please help in this regard.

Thanks

Re: Months comparison in % as Expression

sunny_talwar — Tue, 26 Apr 2016 15:56:56 GMT

04 on the same chart? Not sure I understand