How to combine GL & Sales Order report into 1 ?

[paulyeo11]

Hi All,

By the way from sles order table :-
inv = invoice number

By the way from GL Table
Document No = invoice number

(1) My GL Table Report

Dimension = Document No
Expression = (Sum({<rEVENUE={rEVENUE}>}Amount)*-1)

(2) My Sales Order Table
Dimension - inv
Expression = sum(sales)

May i know how to make above 2 table into 1 ?

Paul Yeo

[paulyeo11]

Enclosed My QVW

[paulyeo11]

Hi All

I have below raw data :
-
YearMonth duration
-
19 Jan 151
19 Feb 120
19 Mar 31
19 Apr 30
19 May 31
19 Jun 30
19 Jul 31
19 Aug 31
19 Sep 30
19 Oct 31
19 Nov 30
19 Dec 91
20 Jan 60
20 Feb 29
20 Mar 32

I can plot the table for monthly avarage table :-

Dimension = YrMth
Expression = duration

May i know how to get the Quarterly average ?

I have try to insert :-

Dimension = YrQtr
Expression = duration

it display nill value

Paul

[Brett_Bleess]

Have a look at the following Design Blog post, will hopefully get you on the right track with things:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

Regards,
Brett