Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pivot Table - Pegar coluna

Srs. Boa tarde.

Gostaria de tirar uma dúvida. Tenho um pivot table, onde me traz alguns dados e ao final uma somatória destes dados. Quer jogar esta somatória para dentro de um gráfico de gauge, mas quero fazer isto pegando o campo desta pivottable. Uma vez que ao final me traz a somatória do que preciso.

Teria como eu pegar um campo ou a soma de uma coluna na pivot table?

Obrigado,

1 Solution

Accepted Solutions

Re: Pivot Table - Pegar coluna

Hi

PFA

7 Replies
Not applicable

Re: Pivot Table - Pegar coluna

Ninguém? Preciso pegar a linha de totalização e colocar em um mostrador.

Re: Pivot Table - Pegar coluna

HI

Gauge charts are used to display the value of a single expression without dimensions.

You can use expression like this in gauge chart, without dimension

=sum(Sales)/Sum({1} total Sales)

Hope it helps

Not applicable

Re: Pivot Table - Pegar coluna

Hi,

But I need to get the sum total of the table.

exemplo.png

But this one was a calculated dimension, like one inteval of dates.

=If( ([Volume_Documentos-1.BUDAT] >= $(vDataInicio) and [Volume_Documentos-1.BUDAT] <= $(vDataFim)), month([Volume_Documentos-1.BUDAT]) & '-' & year([Volume_Documentos-1.BUDAT]))

I need to put the total value on Gauges chart.

exemplo2.png

Understood?

Re: Pivot Table - Pegar coluna

HI

Can you post a sample file?

May be try like this:

=Sum(total Volume) as expression in guage chart

but its better to post a sample file, if it not helps

Not applicable

Re: Pivot Table - Pegar coluna

Yeah, I attached a file on this discussion. Thanks

Re: Pivot Table - Pegar coluna

Hi

PFA

Not applicable

Re: Pivot Table - Pegar coluna

Thank you Mayil Vahanan Ramasamy, your help was very nice!

Community Browser