topic Re: Add Totla to an Object in QlikView

Add Totla to an Object

gidon500 — Tue, 06 Sep 2016 06:44:45 GMT

Hi ,

I have a document , that compare Sales actual vers Budget ,

i have used the FactType , ine line data to creat the ERD

and in the Object I used the FactType , Actual , and Budget ,

and many expresions to create the data

i need to add a Total column accoring to the excel file attached , and the original qvw Document

Need help

thanks

gidon

Re: Add Totla to an Object

bindu_apte — Tue, 06 Sep 2016 06:48:56 GMT

Hi,

It is asking userid. Please give credentials so that will help you out.

Re: Add Totla to an Object

soloeeeoff — Tue, 06 Sep 2016 06:57:54 GMT

Please, give us USERID... That I may try

Re: Add Totla to an Object

gidon500 — Tue, 06 Sep 2016 06:59:25 GMT

wow , sorry

userid : gidon

passwd: david

thanks

Re: Add Totla to an Object

gidon500 — Tue, 06 Sep 2016 07:07:24 GMT

Hi Bindu ,

did you succed to open the file

thanks

gidon

Re: Add Totla to an Object

Anil_Babu_Samineni — Tue, 06 Sep 2016 07:37:26 GMT

Where you are expecting Total column with those sub headers?

Re: Add Totla to an Object

gidon500 — Tue, 06 Sep 2016 07:55:08 GMT

QUARTER_YEAR	2016-Q1		2016-Q2		Total
FactType	Actual	Budget	Actual	Budget	Actual	Budget
Income	1,217,391	237,082	1,325,748	222,203	2,543,139	459,285
Cost	1,054,541	205,804	1,159,293	190,988	2,213,835	396,792

Profit1	162,850	31,278	166,455	31,215	329,305	62,493
%	13.38%	13.19%	12.56%	14.05%	13%	14%

SalesCost	68,669	11,409	70,185	11,409	138,854	22,818
ManagmentCost	59,857	12,780	58,480	12,780	118,337	25,560

Cost2	128,526	24,189	128,665	24,189	257,191	48,378

Profit2	34,324	7,089	37,790	7,026	72,114	14,115
% Profit2	2.82%	2.99%	2.85%	3.16%	2.84%	3.07%

Re: Add Totla to an Object

gidon500 — Tue, 06 Sep 2016 07:56:13 GMT

if you change to dimention to quarters

i want to add total like in the enclosed excel file

gidon

Re: Add Totla to an Object

Anil_Babu_Samineni — Tue, 06 Sep 2016 08:23:36 GMT

Have you tried Transpose with the dimension and Calc. Expr. of two (Actual, budget)

Re: Add Totla to an Object

gidon500 — Tue, 06 Sep 2016 08:55:41 GMT

No i did not

can you show me how ?

Re: Add Totla to an Object

florentina_doga — Tue, 06 Sep 2016 14:59:01 GMT

see attach

Re: Add Totla to an Object

florentina_doga — Wed, 07 Sep 2016 06:57:09 GMT

sorry David. i forgot credentials

user = gidon

password = david

i use binary from your source. i added a little script and chart in interface.

see attach pls.

Re: Add Totla to an Object

gidon500 — Wed, 07 Sep 2016 10:11:11 GMT

thanks