topic Re: pivot table converted in cross table in QlikView

pivot table converted in cross table

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

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 count

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.

Re: pivot table converted in cross table

andrey_krylov — Fri, 26 Oct 2018 07:56:50 GMT

Hi Manoj. Can you show the expression?

Re: pivot table converted in cross table

manoj217 — Fri, 26 Oct 2018 08:02:35 GMT

count(report name)

Re: pivot table converted in cross table

manoj217 — Fri, 26 Oct 2018 08:04:01 GMT

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.

Re: pivot table converted in cross table

andrey_krylov — Fri, 26 Oct 2018 11:35:55 GMT

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

Re: pivot table converted in cross table

vishsaggi — Fri, 26 Oct 2018 11:59:55 GMT

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

Re: pivot table converted in cross table

vinod22kv — Fri, 26 Oct 2018 13:53:47 GMT

Hi,

Hope This video will help you.

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

Regards,

Vinod.