Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

count- every row should have the same result (Total)

Hello

I would like, to have in every row the result from the count. Like in column DS=7.

18-07-_2018_12-01-40.png

I try with SUM(TOTAL Aggr(count({<[Berechnung.Menge_IST]= {">0"}> } distinct  [Berechnung.SalesLine.LINENUM]), [%SalesID] ))/SUM(TOTAL Aggr( Count(Distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))

but the problem is, i have the same result i every column. For every Kanal should be other result.

18-07-_2018_12-11-58.png

When i select specfic Month Feb. and the "Kanal" then is the result true:

18-07-_2018_12-14-10.png

How i can became in overal the right total?

Thank for you help.

1 Solution

Accepted Solutions

May be try this

SUM(TOTAL <[Calendar.Monat]> Aggr(count({<[Berechnung.Menge_IST]= {">0"}> } distinct  [Berechnung.SalesLine.LINENUM]), [%SalesID] ))/SUM(TOTAL <[Calendar.Monat]> Aggr( Count(Distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))

View solution in original post

1 Reply

May be try this

SUM(TOTAL <[Calendar.Monat]> Aggr(count({<[Berechnung.Menge_IST]= {">0"}> } distinct  [Berechnung.SalesLine.LINENUM]), [%SalesID] ))/SUM(TOTAL <[Calendar.Monat]> Aggr( Count(Distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))

View solution in original post