topic Re: Report Format in QlikView

Report Format

svsudhakar — Fri, 26 Dec 2014 10:48:13 GMT

Hi ,

I need the report like below chart .can any one please suggest how to do this.

Manager	Reportee	Total Amount (Direct +Reportees)	Reportee Amount
X	A	100(A Direct Amount)+(Reportees 70+20+30)=210	110
A	B	40 + (Reportees 10+20) =70	30
A	c	20	0
A	D	30	0
B	E	10	0
B	F	20	0

Re: Report Format

arulsettu — Fri, 26 Dec 2014 11:04:02 GMT

can you post any excel data source

Re: Report Format

svsudhakar — Fri, 26 Dec 2014 11:22:25 GMT

Please find the attached sample data source

Re: Report Format

svsudhakar — Fri, 26 Dec 2014 11:26:05 GMT

Please fin the updated one

Re: Report Format

sarfaraz_sheikh — Fri, 26 Dec 2014 11:27:52 GMT

Dear Sudhakar,

You need to post exel data as Arul said above.........I am putting my understanding below.

You need to take 2 Dimension 1) for Manager Field 2) for Reportee Field

And you have to take expression for calculating Reporting Amount:- Sum( Reportee) and have to take one more expression for calculating

Total Amount : Sum( Reportee) + Sum(Direct)

If any doubts then please post you QVW /RawFile/or Exel Data from where u are extracting as it does not clear much more information.

Thanks

Sarfaraz

Re: Report Format

arulsettu — Fri, 26 Dec 2014 11:31:07 GMT

can you check the updated excel is right one. because it contain only two fields

Manager

Reportee

thats all what about other fields

check it and update

Re: Report Format

arulsettu — Fri, 26 Dec 2014 11:49:09 GMT

i made a sample data find the attachment and let me know

Re: Report Format

svsudhakar — Fri, 26 Dec 2014 11:56:08 GMT

Hi Arul,

please check the second sheet. its having 2 sheets one is user data and other one is user wise values.

Re: Report Format

svsudhakar — Fri, 26 Dec 2014 12:00:48 GMT

Hi,

attached the qvw with sample data.

Re: Report Format

arulsettu — Fri, 26 Dec 2014 12:01:03 GMT

what about the Reportees

Re: Report Format

svsudhakar — Fri, 26 Dec 2014 12:08:23 GMT

Reportees values need calculate dynamically based on manager and reportee tagging.

because my table structure have is like this .

Re: Report Format

arulsettu — Fri, 26 Dec 2014 12:22:48 GMT

can you explain bit more

Re: Report Format

svsudhakar — Fri, 26 Dec 2014 12:46:59 GMT

hi Arul,

I have two tables one is user tagging and other one is user wise values.

like below

Table 1:

Manager	Reportee
X	A
A	B
A	c
A	D
B	E
B	F
	x

Table 2:

User	Amount
A	100
B	40
c	20
D	30
E	10
F	20

Now I need the report like below:

First Manager Should come:

Ex :

Manager Reportees Amount

X A 210

A B 70

A C 20

A D 30

B E 20

B F 10

The consideration for calculation should be like this..

For a manager the final amount should be the sum of his amount + sum of his Reportees amount ..

For example for B is manager as per the data he has to reportees so the amount will be calculated as

B's amount + Reportee's amount=40+20+10(B+E+F)=70

Also B is a reportee to Manger A . So Manager A amount will be

A's amount+ Reportess[B+C+D] amount i.e 100+70+20+30=210

Hope now it is clear..

Re: Report Format

Gysbert_Wassenaar — Fri, 26 Dec 2014 13:36:38 GMT

Perhaps this discussion helps: BOM Explosion using Hierarchy & HierarchyBelongsTo