Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vinicius_siquei
Partner - Contributor III
Partner - Contributor III

Total per Category on Dynamic Table

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


Print1.png

1 Solution

Accepted Solutions
Nicole-Smith

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)

View solution in original post

3 Replies
Not applicable

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

Nicole-Smith

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)

vinicius_siquei
Partner - Contributor III
Partner - Contributor III
Author

Nicole,

Your suggestion worked perfectly! Thanks for you help!

The final expression was:

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