Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

pivot table converted in cross table

Hi i have a pivot table in the fields have

report name

report path

month

count of report names

these are the dimensions and expressions, count will shows based on each month

in normal view it will shows the total count based on all months for the particular report. when i do cross table it will shows only the count will be in based on month not the total month countCapture.JPG

it is showing only individual month count when i do cross table it is not showing total months count.

But in normal mode it is showing total month count.

6 Replies
Highlighted
Specialist
Specialist

Hi Manoj. Can you show the expression?

Highlighted
Creator III
Creator III

count(report name)

Highlighted
Creator III
Creator III

i done month table as cross table so it will show the count based on month its fine but i want total count as well.

Highlighted
Specialist
Specialist

Sorry, it seems I do not understand what you are trying to achieve. Maybe you can share a sample

Highlighted
Champion III
Champion III

Did you try checking show partial sums for Month field in your presentation tab of pivot table chart?

Highlighted
Creator
Creator

Hi,

Hope This video will help you.

https://www.youtube.com/watch?v=5eMV5NQY-5g

Regards,

Vinod.