topic Re: Total per Category on Dynamic Table in QlikView

Total per Category on Dynamic Table

vinicius_siquei — Mon, 20 Jan 2014 17:22:10 GMT

Folks,

I have the table below in my application.

On the last column I need to to present the share information. To do that I need to have the Total for every record within each category (GrupoModeloVeiculo). For instance, in the image all records from Big Sport Touring Category should present the Total of 12.

I'm trying to do this by using the following set analysis expression :

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}, GrupoModeloVeiculo=>}Numero_Chassis)

I had the expectation that GrupoModeloVeiculo= would make the expression ignore the GrupoModeloVeiculo dimension and give the total, however its not happening. Could anyone help me ?

Could anyone help me ?

Thanks

Re: Total per Category on Dynamic Table

Mon, 20 Jan 2014 17:29:47 GMT

Hi,

Perhaps the GrupoModeloVehiculo is a dimension that is linked to other dimensions that are limited.

That is the same with TIME: if you do a set analysis on Month (with = to get all months) but do nothing on Quarter or Years, you have done almost nothing.

Fabrice

Re: Total per Category on Dynamic Table

Nicole-Smith — Mon, 20 Jan 2014 17:57:55 GMT

If you want to ignore dimensions, you need to use TOTAL:

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}>} TOTAL Numero_Chassis)

If there are dimensions you want to include, do so like this:

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}>} TOTAL <DimensionToInclude> Numero_Chassis)

Re: Total per Category on Dynamic Table

vinicius_siquei — Mon, 20 Jan 2014 18:18:34 GMT

Nicole,

Your suggestion worked perfectly! Thanks for you help!

The final expression was:

Count({<Ano={'$(vMaxAno)'},Mes={'$(vMaxMes)'},Dia={'<=$(vMaxDia)'}>}TOTAL <Segmento> Numero_Chassis)