Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
tajakovc
New 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

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

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

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

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