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
Specialist
Specialist

How to prepare a pivot table s per this Excel table format

Hi;

Dear all,

The attached excel table carry data for Month actual, Month budget , Month variance YTD Actual ,YTD Budget & YTD Variance. I can load this data & arrange the dimensions as under the description field. My requirement is to arrange the above expressions as in the given format in a pivot table. Can any body guide me as to how this could be achieved?.

 

 

Thanks 

Neville

2 Solutions

Accepted Solutions
Highlighted
Digital Support
Digital Support

Best I can do for you is point you in some right directions that may help:

Design Blog area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Pivot Table help:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Pivot_Table.h...

Training area:

https://www.qlik.com/us/services/training

Sorry I do not have anything better, but hopefully this may help you move things forward if you are still struggling.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

Highlighted
Specialist
Specialist

Dear Brett,

Thanks for your assistance which helps me to resolve some issues. But my issue looks somewhat 

View solution in original post

4 Replies
Highlighted
Specialist
Specialist

Dear Community Members,

Appreciate if some one help me out on this

Highlighted
Specialist
Specialist

Can any one responds to this please

 

Neville

Highlighted
Digital Support
Digital Support

Best I can do for you is point you in some right directions that may help:

Design Blog area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Pivot Table help:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Pivot_Table.h...

Training area:

https://www.qlik.com/us/services/training

Sorry I do not have anything better, but hopefully this may help you move things forward if you are still struggling.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

Highlighted
Specialist
Specialist

Dear Brett,

Thanks for your assistance which helps me to resolve some issues. But my issue looks somewhat 

View solution in original post