Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
manoj217
Contributor 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
andrey_krylov
Valued Contributor

Re: pivot table converted in cross table

Hi Manoj. Can you show the expression?

manoj217
Contributor III

Re: pivot table converted in cross table

count(report name)

manoj217
Contributor III

Re: pivot table converted in cross table

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.

andrey_krylov
Valued Contributor

Re: pivot table converted in cross table

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

vishsaggi
Esteemed Contributor III

Re: pivot table converted in cross table

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

vinod22kv
Contributor

Re: pivot table converted in cross table

Hi,

Hope This video will help you.

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

Regards,

Vinod.