Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Report Format


Hi ,

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

ManagerReporteeTotal Amount (Direct +Reportees)Reportee Amount
XA100(A Direct Amount)+(Reportees 70+20+30)=210 110
AB40 + (Reportees 10+20) =7030
Ac200
AD300
BE100
BF200
13 Replies
Highlighted
Master III
Master III

can you post any excel data source

Highlighted
Creator
Creator

Please find the attached sample data source

Highlighted
Creator
Creator

Please fin the updated one

Highlighted
Contributor III
Contributor III

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


Highlighted
Master III
Master III

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

Highlighted
Master III
Master III

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

Highlighted
Creator
Creator

Hi Arul,

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

Highlighted
Creator
Creator

Hi,

attached the qvw with sample data.

Highlighted
Master III
Master III

what about the Reportees