Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
matteo901p
Partner
Partner

Create own Totals Calculation Expression in a Straight Table

Hi,

i have a problem with a request made by the customer; i have a straight table in my QlikSense App with 2 dimension and 7 measures.
In presentation, every measure in straight table as Totals (sum); now, in the ultimate measure i must change totals with new criteria but in QS i only change : SUM,COUNT,AVG,AUTOMATIC,MAX, MIN, NOTHING.

I must write in the ultimate measure: totals of Expression1 / totals of Expression7 .

Is There solution for this problem?

NB:

Expression1 is: Sum({$<YEARMONTH={'$(vMaxYearMonth)'}>}Sales)

Expression7 is: Sum({$<YEARMONTH={'$(vMaxYearMonth)'}>}Quantity/TOT)

I would that for Totals in Expression7, in above all, result is: Total of Expression1 (sum every rows) / Total of Expression1 (sum every rows).


Thanks for all and sorry 4 my bad english,


Mats

1 Solution

Accepted Solutions
matteo901p
Partner
Partner
Author

I resolve with " dimensionality () " function.

In Expression7:

if(dimensionality()=0,

     Sum({$<YEARMONTH={'$(vMaxYearMonth)'}>}Sales) / Sum({$<YEARMONTH={'$(vMaxYearMonth)'}>}Quantity/TOT))

View solution in original post

1 Reply
matteo901p
Partner
Partner
Author

I resolve with " dimensionality () " function.

In Expression7:

if(dimensionality()=0,

     Sum({$<YEARMONTH={'$(vMaxYearMonth)'}>}Sales) / Sum({$<YEARMONTH={'$(vMaxYearMonth)'}>}Quantity/TOT))