Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
buenas noches
acudo a ustedes para ver como puedo hacer que se repita la cantidad vendida
lo que pretendo lo que marco en amarillo es la venta del articulo "81051"
Lo estoy tratando de replicar en qlikSense pero no se como puedo hacer que se repita, en lo que marco en amarillo se tendría que repetir los "7,372"
Espero me puedan apoyar ya que no logro dar el como se puede hacer
mi Set Analysis es :
Sum({<ArtDOH={'8'}>}Cantidad_Vendida)
Mil gracias por su apoyo
Accepted Solutions
It looks like there may be some changes you need to make to the data model. For instance, if you try to Join two tables together when they both share the same fields, you can sometimes run into issues of mixed granularity as described in this Henric Cronstrom article, as well as this one. Here's an example of what they may look like when joining tables in the Data Load Editor:
The ideal way for you to address the issue would be to adjust your data model accordingly. However, if you don't have control over the load script or you just need to get this working for the one chart, you should probably be able to achieve this using this expression in your pivot table:
=Only(Aggr(NODISTINCT Sum([Cantidad Vendida]), [Art]))
This works by using the Aggr() function with the NODISTINCT keyword and the Only() function. The Aggr() function essentially acts as a Group By clause for chart expressions, to use a SQL analogy. So we want Sum([Cantidad Vendida]) grouped on the [Art] dimension but we want to the Sum() value to be returned for each row rather than just for one row. That last part is handled by the NODISTINCT keyword. The Only() function is an aggregation function that returns a value only if there is one possible value to return. That works for us in our case because the Sum() value could only be one possible value since we already have our pivot table grouping this field by the [Art] dimension.
That expression should give you the desired result:
To learn more about why the Aggr() function was necessary, see this Qlik Help page about nested aggregations. To learn more about why the Only() function was helpful to us, see this Henric Cronstrom article that explains its usefulness.
It looks like there may be some changes you need to make to the data model. For instance, if you try to Join two tables together when they both share the same fields, you can sometimes run into issues of mixed granularity as described in this Henric Cronstrom article, as well as this one. Here's an example of what they may look like when joining tables in the Data Load Editor:
The ideal way for you to address the issue would be to adjust your data model accordingly. However, if you don't have control over the load script or you just need to get this working for the one chart, you should probably be able to achieve this using this expression in your pivot table:
=Only(Aggr(NODISTINCT Sum([Cantidad Vendida]), [Art]))
This works by using the Aggr() function with the NODISTINCT keyword and the Only() function. The Aggr() function essentially acts as a Group By clause for chart expressions, to use a SQL analogy. So we want Sum([Cantidad Vendida]) grouped on the [Art] dimension but we want to the Sum() value to be returned for each row rather than just for one row. That last part is handled by the NODISTINCT keyword. The Only() function is an aggregation function that returns a value only if there is one possible value to return. That works for us in our case because the Sum() value could only be one possible value since we already have our pivot table grouping this field by the [Art] dimension.
That expression should give you the desired result:
To learn more about why the Aggr() function was necessary, see this Qlik Help page about nested aggregations. To learn more about why the Only() function was helpful to us, see this Henric Cronstrom article that explains its usefulness.
