Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi every Body,
I have a Question, I try to create the report in Qlik Sense that previously created in Qlik view.
The problem is that the Show Partial Sum in Qlik view does not give me the same number as Total option in Pivot table in Qlik sense. Please guide me.
Hi, looks like QlikView is showing the max value, and Qlik sense is doing a Sum of values, are you using the same expresssion?
Default pivot table doen't have an option the select what ling of total you want, it uses the same expression as any other row.
Id each Veranstaltung and previous dimensions has only one value, you can use Max() instead of Sum()
If you nee d asum beacuse there are many value, you can try with dimesnionality() like:
If(Dimensionality()>6, Sum(Values), Max(Aggr(Sum(Values),Dim1FieldName,Dim2FieldName...Dim5FieldName)
So form Veranstaltung it does the sum of values, and the previous dimensions uses the max value calculated for each Veranstaltung.
Hi, looks like QlikView is showing the max value, and Qlik sense is doing a Sum of values, are you using the same expresssion?
Default pivot table doen't have an option the select what ling of total you want, it uses the same expression as any other row.
Id each Veranstaltung and previous dimensions has only one value, you can use Max() instead of Sum()
If you nee d asum beacuse there are many value, you can try with dimesnionality() like:
If(Dimensionality()>6, Sum(Values), Max(Aggr(Sum(Values),Dim1FieldName,Dim2FieldName...Dim5FieldName)
So form Veranstaltung it does the sum of values, and the previous dimensions uses the max value calculated for each Veranstaltung.
Hi and tanks to answer,
the second part of your formula I had understand yes it should be Max(Aggr(Sum(Values),Dim1FieldName,Dim2FieldName...Dim5FieldName) but why I should use Dimensionality() and why bigger than 6?
could you please explain me why Dimensionality()>6?
*just for info : I have generally 9 Dimension.
thanks in Advanced
Hi, you can add a measure with just Dimensionality() and check how it evaluates for each dimension. https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/In...
Another option could be using count of Veranstaltung, like:
If(Count(Distinct Veranstaltung)>1, Max(Aggr(...)), Sum(...))